Re: Lock Q's (HELP!!!)

jkyf0131_at_hotmail.com (JK Yao) kirjoitteli seuraavaa:

>dear all,
>
>I got a user complain that she cannot update the table, since someone
>is updating the same table. Anyone know how can I find out who are
>querying or updating that table at the same time?
>Which view I should query?

Try this:

select b.username, c.object_name, a.sid, b.serial#,MACHINE from v$lock a, v$session b, sys.dba_objects c where a.sid > 3
and a.sid = b.sid and a.id1 = c.object_id ;

Tuomas Received on Wed Sep 19 2001 - 01:57:57 CDT