Re: Oracle 7.3 LOCK Script

Try this for something quick:

select * from v$session
where sid in (select sid from v$lock where block=1);

Berj

In article <8emoa4$cfl1_at_nova.entelchile.net>,   "Jose A. Silva" <jsilvae_at_yahoo.com> wrote:
> Does anyone have a script to show the current lockings in the
 database, and
> who is locking who ?
> Thanks.
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue May 02 2000 - 00:00:00 CDT