SWITCH_TIME in Resource Manager Not Working For Scheduler Job When USE_CURRENT_SESSION=FALSE
(Doc ID 2371314.1)
Last updated on MARCH 12, 2021
Applies to:Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Information in this document applies to any platform.
The Resource Manager is created with the CANCEL_SQL with SWITCH_TIME so that the Long Running queries will be cancelled according to the SWITCH_TIME.
Tthe CANCEL_SQL is working fine and cancelling the SQL according to the SWITCH_TIME by executing the scheduler job through the foreground process using USE_CURRENT_SESSION=TRUE (By Default). But the same is not working when the job is executed by the Job Queue Process with USE_CURRENT_SESSION=FALSE.
This behavior is happening on several Database Versions and explained in the below Test Case.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document