Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Any way to know database lock?

Re: Any way to know database lock?

From: Mark D Powell <Mark.Powell_at_eds.com>
Date: 11 Mar 2005 05:32:33 -0800
Message-ID: <1110547953.899083.230920@l41g2000cwc.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US