Skip to Main Content

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!

Trigger to kill lock session

ABU JAMANApr 18 2022

Hi all,
We are in 19C on linux. I want to create a trigger that would kill the blocked sessions in the database when it is detected but i do not know how to do it. I appreciate if somone help me . Thanks.

This post has been answered by Solomon Yakobson on Apr 18 2022
Jump to Answer
Comments
Post Details
Added on Apr 18 2022
3 comments
1,051 views