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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Efficient way to detect lock contention/blocking sessions

Re: Efficient way to detect lock contention/blocking sessions

From: Hemant K Chitale <hkchital_at_singnet.com.sg>
Date: Fri, 24 Mar 2006 23:00:44 +0800
Message-Id: <6.2.1.2.0.20060324230010.044e3700@pop.singnet.com.sg>

Build a script using $ORACLE_HOME/rdbms/admin/utllockt.sql [for which catblock.sql is a pre-requisite]

Hemant
At 12:47 AM Friday, jayaraj rengarajan wrote:

>I would like to implement proactive/notification (possibly to the pager
>and mail) process whenever we see session blockers holding locks. In the
>worst case scenario, lock contention contributes huge latch wait and
>application activities become almost hang status.
>
>I would appreciate if anyone in this list implemented a script which runs
>efficiently as a schedule helping DB administration.

Hemant K Chitale
http://web.singnet.com.sg/~hkchital

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Mar 24 2006 - 09:00:44 CST

Original text of this message

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