Skip to Main Content

SQL & PL/SQL

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!

how to kill automatically blocking session

Ora_83May 27 2013 — edited May 27 2013
Hi

I have a database username called "app" which comes from application server.

If this user ("app") is blocked more than 5 minutes, I want the holder to be killed automatically.

How can I achieve this ?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 24 2013
Added on May 27 2013
6 comments
4,389 views