Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Efficient way to detect lock contention/blocking sessions
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.
Thanks
Jay
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Mar 23 2006 - 10:47:43 CST