Re: set dml_lock value without bouncing db?

Sounds like ORA-0055

You don't have enough DML locks.

Setting it to 300 could be entirely inappropriate.

DML_LOCKS is a derived value.

Where does it come from?

DML_LOCKS = TRANSACTIONS * 4 TRANSACTIONS = SESSIONS * 1.1 SESSIONS = 1.1 * PROCESSES + 5 PROCESSES is derived from PARALLEL_MAX_SERVERS

PARALLEL_MAX_SERVERS is derived from the values of CPU_COUNT, PARALLEL_AUTOMATIC_TUNING, and PARALLEL_ADAPTIVE_MULTI_USER

....

It might be easier to comment out DML_LOCKS in your init.ora, bounce the database and then check the default value of DML_LOCKS. It's 748 on my lowly workstation.

Setting it to 300 may be worse than the default.

Jared

On Tuesday 24 April 2001 20:55, Guang Mei wrote:
> Is this possible? Our 8.0.5 Oracle db (on Sun box) is 7x24. I got error
> saying Maximum number of DML exceeded. I tried
>
> alter system set dml_lock = 300
>
> but it did not work.
>
> TIA
> _________________________________________________________________
> Get your FREE download of MSN Explorer at http://explorer.msn.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jared Still
  INET: jkstill_at_cybcon.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).