Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Any way to know database lock?
Oracle provides a script to "Print out the lock wait-for graph in a
tree structured fashion." named utllockt.sql in the
$ORACLE_HOME/rdbms/admin directory.
You may also want to look at the contents of the catblock.sql script to see numerous views that show sessions waiting on locks, sessions holding locks that other sessions want (blockers) etc...
HTH -- Mark D Powell -- Received on Fri Mar 11 2005 - 07:32:33 CST
![]() |
![]() |