Resource Manager - how to verify if switch_estimate parameter works correctly?
I'm using 19.14 DB with Multitenant on Exadata.
For one PDB I created plan which is suppose to automatically manage runaway queries:
DBMS_RESOURCE_MANAGER.create_plan_directive ( plan => 'MY_PLAN', group_or_subplan => 'OTHER_GROUPS', shares => 10, parallel_degree_limit_p1 => 4, parallel_server_limit => 20, parallel_queue_timeout => 60, pq_timeout_action => 'RUN', switch_group => 'MID_RUN', switch_time => 60, switch_estimate => TRUE, switch_for_call => TRUE ); DBMS_RESOURCE_MANAGER.create_plan_directive ( plan => 'MY_PLAN', group_or_subplan
0