Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Script to Kill long running queries

AzmatDec 2 2012 — edited Apr 18 2013

Hi Friends,

Would be obliged if someone can help me with the following required script.

I need a script please which kills any session recieved from a certain user (i.e userA) which stays on the DB for more then 5 minutes. if a query has been executing for more then 5 minutes it should be killed by the script.

Any help would be highly appreciated my friends :)

regards
Azmat

Locked Post

New comments cannot be posted to this locked post.

Locked on May 16 2013

Added on Dec 2 2012

#dba, #general-database-discussions, #performance, #script, #session, #sql

7 comments

1,993 views