Lixora's DB Home

MultipleLogWriters in12cCausing Enabling and Disabling of Adaptive ScalableLogWriter Workers Which Cause High 'logfilesync' Wait Event (文档 ID2174075.1) In this Document APPLIES TO: Oracle Database - Enterprise Edition - Version 12.1.0.1 and l...

ORA-06553: PLS-801: internal error [56319], ORA-06544: PL/SQL: internal error, arguments: [56319], [], [], [], [], [], [], [], ORA-00604 when using different bit datafiles than Oracle executable (Doc ID 1436552.1) To Bottom APPLIES TO:.

"SQL*Net message from client" Reference Note This is a reference note for the wait event "SQL*Net message from client" which includes the following subsections: Brief definition Individual wait...

"SQL*Net message from dblink" Reference Note This is a reference note for the wait event "SQL*Net message from dblink" which includes the following subsections: Brief definition Individual wa...

In this Document Purpose   Questions and Answers   References Applies to: Oracle Net Services Information in this document applies to any platform. ***Checked for relevance on...

最近在学习vage 的书后，简单画了个图总结下。内容实在太多了，很多细节没有画。

如何分析诊断收集信息 1.       查看AWR 报告中high paring 和high version部分内容   具体查看这几个部分的内容：'SQLordered by Parse Calls' or 'SQL ordered by Version Count'     SQL ordered by Parse Calls 关于这部分中的sql 解析执行是否过高，或者

首先明确一个事情：cursor pin s wait on x 是症状（结果），不是根本原因。 mutex related wait event "cursor: pin S wait on X" 一般原因： 》频繁硬解析（解析时间高. 找出解析时间高的原因很关键）----可能性最大 》high version counts 》bug 如何诊断？ 1.AWR