Database Administration (MOSC)

MOSC Banner

Resource Manager - question regarding pq_timeout_action argument to CREATE_PLAN_DIRECTIVE

edited Nov 21, 2023 1:21PM in Database Administration (MOSC) 4 commentsAnswered ✓

DBMS_RESOURCE_MANAGER.CREATE_PLAN_DIRECTIVE procedure has "pq_timeout_action" argument which can be set to CANCEL or RUN.

My question refers to situation when we set it to "RUN" so when statements waits in the queue for "parallel_queue_timeout" it will be executed anyway but - as official Oracle documentation states - "might get downgraded if parallel servers are unavailable" (there is only this short statement there without examples).

Does this "downgrade" only applies to parallelism degree or takes into account "switch_group" settings for the same plan directive?

Otherwise speaking in which consumer group would this statements be executed after timeout:

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