Current Table Activity

[Barabas]

Hey

is there any way i can see the current activity on a table / DML ,

i was performing some updates, and then i issue a simple delete statement & sqlplus hung completley?

Having a bad monday, so any help is again greatly appreciatated?

Thanks

[KenEwald]

You could select from v$sqlarea for the table name .. but ..

I'll bet you have a blocking lock.

A session with a blocking lock will sit in a status of "enqueue" until the exclusive lock is released. The following query shows sessions waiting for an exclusive lock:

SELECT * FROM V$SESSION_WAIT WHERE EVENT = 'enqueue';

[gpsingh]

From v$access , u can verify if anybody is using that object,
then from v$lock and v$session u can check who is using and if it is locked.
From v$transaction u can confirm if any transactions are going on any of the blocks
of that object.