'DBMS_RESOURCE_MANAGER : CANCEL_SQL to cancel long waiting queries because of other blocking session
I am exlporing options provided by DBMS_RESOURCE_MANAGER to cancel sql queries which are waiting because of another non-idle blocking session.
CANCEL_SQL with MAX_IDLE_BLOCKER_TIME,as far as I understand, will work if the blocking session is idle and it will cancel the blocking SQL & not the waiting SQL.
How can we use CANCEL_SQL to cancel the waiting SQL after it waited for N seconds.
So if the v$session looks like below
I need to cancel SQL running in 34 after last_call_et reaches say 10 secs
Thanks
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|

