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