DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: DML LOCKS EXCEEDING ERROR CONSTANTLY!!PROBLEM!!!

  1. #1
    Join Date
    Feb 2001
    Posts
    286
    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

  2. #2
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    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
  •  


Click Here to Expand Forum to Full Width