Re: Any one has good script to find out "Who lock what" from 9i

From: Anton Buijs <aammbuijs_at_xs4all.nl>
Date: Fri, 28 Jun 2002 21:46:50 +0200
Message-ID: <afied4$j4b$1@news1.xs4all.nl>

Views dba_waiters and dba_blockers are slow in my experience. Can't say anything about 9i, not used it yet. Not so sofisticated as in note 148517.1 but quick is: SELECT * FROM v$lock
WHERE request !=0
OR block !=0
ORDER BY id1, block desc
;

It shows you the blocking and waiting locks. The list should not be too long normally.
The sessions that wait on a blocking session have the same value for id1 for a TX lock. You now the SID's then.
From there you can do other queries.

Chuck <chuckh_at_softhome.net> schreef in berichtnieuws afhqvq$ecuv2$1_at_ID-85580.news.dfncis.de...
| What's wrong with using the dba_waiters and dba_blockers views? Don't they
| exist in 9i?
|
| "Evan Cao" <eecao_at_yahoo.com> wrote in message
| news:a618084.0206280604.65f37b0a_at_posting.google.com...
| > I had scripts from metalink note 148517.1 to find out "who lock what".
It
| works
| > fine prior to 9i. It took too long under 9i.
| > Thanks.
|
|
Received on Fri Jun 28 2002 - 14:46:50 CDT