I have multiple dbms jobs running and end users are modifying data at the same time. Sometime it looks like a session is locking some other sessions. Does someone have a sql statement to determin which session is locking the others?
and then you can select from
I'm stmontgo and I approve of this message
Run the catblock utlity and then look at the tables dba_locks and dba_blockers.
I also use ...
from dba_objects a,v$session b,v$locked_object c
where a.object_id=c.object_id and
Thank you all very very much
Click Here to Expand Forum to Full Width