There is Wait on Resmgr:pq Queued Permanently (文档 ID 1503339.1)

APPLIES TO:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.

SYMPTOMS

After upgrade to 11.2.0.3, we see wait event resmgr:pq queued permanently.

CAUSE

 Not enough parallel slaves available.

SOLUTION

Increased parallel_servers_target parameter.  Parallel_servers_target should be 50-75% of parallel_max_servers.   Recent experience has shown that fewer DOP downgrades occur when it's 50% of parallel_max_servers.  This is because complex SQL statements can use >  2 slave sets.

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/21754115/viewspace-1379045/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/21754115/viewspace-1379045/