Resource Manager - question regarding pq_timeout_action argument to CREATE_PLAN_DIRECTIVE
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: