This is not really anything new - in fact Tanel Poder has already blogged about it a while ago. Tanel has specifically covered the handling of "urgent" TCP packets and how this could be used to signal a "cancel" to another process, however this only works on Unix environments and not with Windows SQL*Plus clients. In Tanel's article it is also mentioned that there is an officially documented way of doing this via the Resource Manager if you happen to have an Enterprise Edition license.
In my quick tests however the call to DBMS_RESOURCE_MANAGER.SWITCH_CONSUMER_GROUP_FOR_SESS using "CANCEL_SQL" as consumer group only errors out with ORA-29366 saying that the specified consumer group is invalid.
Recent comments
17 weeks 9 hours ago
26 weeks 5 days ago
28 weeks 3 days ago
31 weeks 5 days ago
33 weeks 6 days ago
43 weeks 3 days ago
45 weeks 11 hours ago
46 weeks 13 hours ago
46 weeks 1 day ago
48 weeks 6 days ago