Re: Efficient way to detect lock contention/blocking sessions

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