An html email alert whenever any table in oracle database gets blocked for more than 3 minutes. The email should show a table with column name as Table blocked,User Blocking,users blocked and Duration of block.
It should be done through a oracle [url removed, login to view] procedure would called using a DBMS Scheduler or DBMS jobs .The procedure should be in such a way that if there is no block it should not send anything. If there is any block then an html email should be sent with details of block in it. This email should would be going to multiple users.
I need an procedure which would check if there is any database block(like table block etc) for more than a minute and if it finds anything blocked then it should send a html email containing a table structure with column name as Table blocked,User Blocking,users blocked and Duration of block along with their respective details.If there is nothing blocked then it should send anything.
I would create the job myself by calling this procedure every 5 minutes.