There is Wait on Resmgr:pq Queued Permanently (文档 ID 1503339.1)
APPLIES TO:
Oracle Database - Enterprise Edition - Version 11.2.0.3 and laterInformation 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博客 ” ，链接：https://blog.itpub.net/21754115/viewspace-1379045/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
最新文章
- mysql报关于用户密码1045(28000)，几种处理方法
- A resource type with the name 'ora.daemon.type' is already registered
- AWR报告参数：DB TIME和DB CPU
- UDEV规则参数详细解释使用
- Redhat7 Udev绑定单路径设备方法
- Linux平台的多路径软件multipath的使用案例
- sqlldr Field in data file exceeds maximum length
- sqlldr 时碰到错误 ORA-01722: invalid number
- 【LISTENER】使用“alter system register;”解决动态监听注册缓慢问题
- 通过xtts迁移单实例文件系统表空间到RAC ASM存储表空间
