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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
