Database Administration (MOSC)

MOSC Banner

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       

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center