Re: Locked rows

From: David Sisk <davesisk_at_ipass.net>
Date: Sun, 03 May 1998 04:45:52 GMT
Message-ID: <4ES21.30$P3.2100441@news.ipass.net>

I don't have the exact SQL handy in mind at this moment, but you'll need to join the following tables:

sys.dba_dml_locks (this will show you tables, not sure if you can get rows....)
v$session
v$sql

Good luck,
Dave

Paul Bennett wrote in message <3548C141.FF86D2C5_at_cc.gatech.edu>...
>I am looking for a script that will show me what rows/objects are locked
>and who locked them and for how long, and what the SQL was that locked
>them, and any other info that will help me figure out what the hold up
>is on the tables so that I can fix the SQL in the client application to
>reduce contention.
>
>I am having trouble finding all this information in the V$ tables.
>
>Thanks!
>
>
>
Received on Sat May 02 1998 - 23:45:52 CDT