Database DataWarehousing (MOSC)

MOSC Banner

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

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