解析失败导致大量的Library Cache Lock锁Library Cache Lock on Namespace SQL AREA BUILD(82) Caused by Failed Parse (Doc ID 2294281.1)
简介Library Cache Lock on Namespace SQL AREA BUILD(82) Caused by Failed Parse (Doc ID 2294281.1存储过程解析 ... 阅读全文
分类： Oracle
【MOS】High Version Count Due To BIND_MISMATCH (Doc ID 336268.1) -- 10503 events事件介绍
介绍修复bug 2450264引入了一个新事件（10503），该事件允许用户指定字符绑定缓冲区长度。根据所使用的长度，子游标中的字符绑定可以全部使用相同的绑定长度创建。对于绑定变量,ORACLE根据变 ... 阅读全文
【MOS】故障排除“cursor: pin S wait on X”等待事件 (Doc ID 2901617.1)
故障排除“cursor: pin S wait on X”等待事件 (Doc ID 2901617.1Troubleshooting 'cursor: pin S wait on X' waits. ... 阅读全文
【MOS】How to Identify Hard Parse Failures Such as Error=923 (Doc ID 1353015.1)
GOAHard parse time may be impacted when there are a high number of parse errors.This may be noted i ... 阅读全文
【MOS】How to Determine the Blocking Session for Event 'cursor: pin S wait on X' (Doc ID 786507.1)
APPLIES TOOracle Database Cloud Schema Service - Version N/A and lateOracle Database Exadata Expre ... 阅读全文
Mos脚本version_rpt3_25.sql用于排查高版本游标的原因
简介SQL 版本数过高 – 原因判断脚本 (Doc ID 1985045.1High SQL Version Counts - Script to determine reason(s) (Doc ... 阅读全文
【MOS】故障排除 版本数高(High Version Count)的问题 (Doc ID 2896923.1) SQL 版本数过高 – 原因判断脚本 (Doc ID 1985045.1) Troubleshooting High Version Count Issues (Doc ID 296377.1)
故障排除: 版本数高(High Version Count)的问题 (Doc ID 2896923.1参考MOTroubleshooting: High Version Count Issues ... 阅读全文
【MOS】高版本游标数的SQL语句在升级到12.2及更高版本后会导致数据库性能下降 (Doc ID 2469639.1)
【MOS】高版本数（>1024）的SQL语句在升级到12.2及更高版本后会导致数据库性能下降 (Doc ID 2469639.1High Version Counts For SQL Stateme ... 阅读全文
由于BIND_EQUIV_FAILURE导致的游标不能共享问题
简介12.2 Cursor Mutex: x Due to Sql not Shared Because of Bind_equiv_failure (Doc ID 2539161.112.2 由于 ... 阅读全文
【MOS】故障排除 Shared Pool优化 (Doc ID 1523934.1) Troubleshooting: Understanding and Tuning the Shared Pool (Doc ID 62143.1)
简介故障排除：Shared Pool优化 (Doc ID 1523934.1Troubleshooting: Understanding and Tuning the Shared Pool (Do ... 阅读全文
