| locks& deadlocks [message #56943] |
Thu, 08 May 2003 10:44  |
Tony
Messages: 190
Registered: June 2001
|
Senior Member |
|
|
Hello,
I have a lock question, does oracle allocate a table level lock when enforcing referential integrity? we re having strange deadlocks in our database and I suspect frequent lock escalation by Oracle. There are very simple delete statements failing in production with a deadlock, it doesn t make sense except the table is referenced by a million other tables. First question how does Oracle manage locks when enforcing referential integrity.
Second question: we are trying to replicate the situation in our development database, I need to capture all locks held in the database for a given period of time and log it to a file. Locks happen so quickly i can't see them through dynamic views or oem lock manager. How do i capture locks in a log file?
thanks a lot
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
