Lixora's DB Home

MultipleLogWriters in12cCausing Enabling and Disabling of Adaptive ScalableLogWriter Workers Which Cause High 'logfilesync' Wait Event (文档 ID2174075.1)In this DocumentAPPLIES 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