How to fix resmgr:pq queued?
Hi,
Exadata, 19.14 two node RAC on RHEL7
Multitenant
small DW which sees alot of resmgr:pq queued. I understand that this is quing for running queries in parallel.
Some parameters that are set:
cpu_count 30
parallel_max_servers 12
parallel_servers_target 8
parallel_degree_limit 14
parallel_degree_policy ADAPTIVE
Where to start?
Regards
WC_DBA