The following table will show me whether or not a session is blocking
another, but is it possible to find out how long the session has been
blocking others?


SQL> desc dba_dml_locks;
Name Null? Type
------------------------------- -------- ----
SESSION_ID NUMBER
OWNER NOT NULL VARCHAR2(30)
NAME NOT NULL VARCHAR2(30)
MODE_HELD VARCHAR2(13)
MODE_REQUESTED VARCHAR2(13)
LAST_CONVERT NUMBER
BLOCKING_OTHERS VARCHAR2(40)

SQL>


Systems Operations, Thus Plc.
.
. . _
www.thus.net www.demon.net
email. david.[Email address protected]
internal. 740 4156
external. 0141 566 4156
mobile. 07880 502093

Oracle LazyDBA home page