check out $ORACLE_HOME/rdbms/admin/utlockt.sql
joe
>>> [EMAIL PROTECTED] 08/22/01 02:46PM >>> 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
|
- Locking Issue Kevin Lange
- RE: Locking Issue JOE TESTA
- RE: Locking Issue Christopher Spence
- RE: Locking Issue Kevin Lange
- RE: Locking Issue Mark Leith
- Locking issue Libal, Ivo
- Re: Locking issue Jared Still
- Re: Locking issue JOE TESTA
- Re: Fwd: RE: Locking issue Jared . Still
- RE: Fwd: RE: Locking issue Jamadagni, Rajendra
- Re: Fwd: Re: Locking issue Jared . Still
- Locking Issue Hamid Alavi