'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

enter image description here

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