Re: Way to view locks - who,what,where

In article <X6V7TB1w165w_at_iowegia.uucp>, bob_at_iowegia.uucp (Bob Powers) writes:
|> Does anyone have a SQL script available that will display all of the
|> locks, who has them, what they are on, what type they are and who is waiting
|> on them. THis would be like the lock screen in SQLDBA Monitor but without
|> having to fire monitor up.

No script, but...

look in the back of the DBA manual for the V$ views

V$_LOCK
V$LOCK
V$LATCH

|>
|> This would be used when a user calls and is locked up. I could run this
|> script and tell them who and what is holding them up
|>
|> Bob Powers
|> bob_at_ia-ngnet.army.mil
 

-- 
                               John Peach
                           Chevron (UK) Ltd.
   Ninian House, Crawpeel Road, Altens, Aberdeen, AB1 4LG, Scotland.
   Internet: epeas_at_aberdeen.chevron.com       Phone: +44 224 242637