Re: How to see locks

From: Winnie Liu <oracle_dba_at_zdnetmail.com>
Date: Fri, 23 Oct 1998 19:45:29 -0700
Message-ID: <70remt$onf@dfw-ixnews4.ix.netcom.com>

check the view v$locked_object

Winnie

dasingh_at_my-dejanews.com wrote in message <70qg4m$qn4$1_at_nnrp1.dejanews.com>...
>This might be a silly question, but I would appreciate any responses.
>
>Is it possible to check which and if any tables are locked at the begining
of
>a stored procedure?
>
>I cannot find a simple sql command to do this. There doesn't seem to be a
>user_locks or all_locks table either.
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Fri Oct 23 1998 - 21:45:29 CDT