标签: Mos
Database Hang With 'cursor: mutex X' Contention Due To High Version Count Under LANGUAGE_MISMATCH (D ... 阅读全文
【MOS】RAC 环境中最常见的 5 个数据库和或实例性能问题 (Doc ID 1602076.1)
RAC 环境中最常见的 5 个数据库和/或实例性能问题 (Doc ID 1602076.1Top 5 Database and/or Instance Performance Issues in R ... 阅读全文
解析失败导致大量的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存储过程解析 ... 阅读全文
【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】故障排除 版本数高(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 ... 阅读全文
【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 ... 阅读全文
【MOS】收集统计信息导致游标失效ROLL_INVALID_MISMATCH Rolling Cursor Invalidations with DBMS_STATS.AUTO_INVALIDATE (Doc ID 557661.1)
APPLIES TOOracle Database - Personal Edition - Version 10.1.0.2 and lateOracle Database Cloud Sche ... 阅读全文