DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: blocking notification

  1. #1
    Join Date
    Nov 2000
    Posts
    440

    blocking notification

    I had a user that forgot to log out and he locked 2-3 other jobs for about 11 hours. I would like to setup something in oem grid control to monitor this.
    How can i setup a rule that if a user is blocking for more than 20 minutes, to send me an e-mail about this? Im on 10.2.0.3.

  2. #2
    Join Date
    Nov 2000
    Posts
    440
    I cannot use Metric "Blocking Session Count" solution because blocks is not a problem if the block is for a short period of time.

    I need to be notified if a block last a long time like 20 minutes.
    Than a user-defined-metric with an sql statement would be my solution.

    Does anyone has a query that would spot blocking session for more than a certain amount of time?

  3. #3
    Join Date
    Nov 2006
    Location
    Sofia
    Posts
    630
    You can setup the Oracle Resource Manager to kill the session when it blocks another session for more than specific ammount of time.
    About the query, look at v$session

    Regards

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width