dml_locks is not modifiable with and alter system or alter session command.
You can check parameter for these attributes from v$parameter.
HTH,
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, April 25, 2001 1:35 AM
What was your
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
What was your exact error?
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
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