-
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.
-
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?
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|