Re: How to see locks

From: <dasingh_at_my-dejanews.com>
Date: Mon, 26 Oct 1998 16:27:35 GMT
Message-ID: <7127tm$hlg$1@nnrp1.dejanews.com>

Thank You, Winnie.

Singh

In article <70remt$onf_at_dfw-ixnews4.ix.netcom.com>, "Winnie Liu" <oracle_dba_at_zdnetmail.com> wrote:
> 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
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Oct 26 1998 - 10:27:35 CST