SWITCH_FOR_CALL Option in Resource Manager does not work
(Doc ID 1451835.1)
Last updated on FEBRUARY 28, 2019
Applies to:Oracle Database - Enterprise Edition - Version 18.104.22.168 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud 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
Information in this document applies to any platform.
SWITCH_FOR_CALL = TRUE is set in a resource manager plan directive. Thus, the sessions are automatically switched to another consumer group when a switch criteria is met (SWITCH_TIME).
The problem occurs when the current top-level call completes. The Resource Manager does not return the session to its original resource consumer group.
The SWITCH_FOR_CALL works fine when PL/SQL is involved in the statement and does not work for other simple queries.
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