-
Hi!
Working on Oracle v8i with OS as NT.
We have roughly 1000 tables in Production database and around 40+ users.
Are the following undermentioned INIT.ORA parameters set accurately to support the above
users and tables!
init.ora Parameters:
dml_locks integer 2200
enqueue_resources integer 3244
event string 10262 trace name context forev
er, level 10000
shared_pool_reserved_size string 1572864
shared_pool_size string 31457280
java_pool_size string 20971520
large_pool_size string 614400
Earlier DML_LOCKS were 800 when I got the error message:max no. of DML_LOCKS exceeded!
So I increased it to 1800 still I got the same error message.
Again now I have increased DML_LOCKS to 2200 but again the same error message is coming!
Now to what figure should I set DML_LOCKS finally to!
Thanks & Regards,
Amit.
Oracle DBA (OCP) v8i,v9i
-
Hi
Maybe you have to also check the application using the oracle db, if locks are being used explicitly (unneccessarily also) by the programmer...
oracle has implicit & good locking facility which in itself is sufficient instead of hard coding locks further in the application..
HTH.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|