"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."
Back to the experts
................
We have
an application that, litterally overnight, developed locking
issues.
Our users
start working just fine. Then, right now cause unknown, our
inserts start being blocked. Usually there are so many so fast
that we do not even know what is causing the original
lock.
The
tables the users are being blocked from have multiple triggers and the
tables that these triggers point to ofen have triggers of their
own.
So, the
scenario is
1.
Web Application pointing to an Oracle 8.0.5 database.
2. Things
start out just fine.
3. At a
variable time later (i.e. not the same time of day, not the same
cumulated time since startup, etc.) locks start to appear against our main
table. The users getting the locks are trying to insert a
record.
4. Locks
cascade until the only recourse is to restart the
database.
We are
having trouble tracing the locks back to their origin.
There has
got to be 1 thing that is causing the start of this
cascade.
If anyone
has any insights on how to find this one cause ... I would appreciate
hearing them.
And , if
you happen to have any scripts that would help me trace the locks thru the
database I would appreciate them also.
Thanks
Kevin
