Tag Archives: cursor: pin S wait on X

统计信息收集出现DFS等待导致实例HANG死

Posted on 2013/07/07 by yangtingkun

客户10.2.0.4 RAC环境，出现大量的library cache lock和cursor: pin S wait on X等待，经分析是由于统计信息收集僵死导致的。 数据库在8点到9点期间，数据库两个节点都存在明显的cursor: pin S wait on X和library cache lock的等待： Event Waits Time(s) Avg   Wait(ms) %   Total Call Time Wait   Class cursor:   pin S wait on X 1,573,056 30,651 … Continue reading →

Posted in BUG | Tagged , , , , | Leave a comment

AWR中出现严重kksfbc child completion等待

Posted on 2011/12/08 by yangtingkun

一个客户压力测试的AWR报告中出现了严重的kksfbc child completion等待。 数据库版本为10.2.0.5，其TOP 5等待事件为： Event Waits Time(s) Avg Wait(ms) % Total Call Time Wait Class kksfbc child completion 174,808 8,678 50 27.2 Other db file scattered read 106,665 6,807 64 21.3 User I/O log file sync 130,582 6,592 50 … Continue reading →

Posted in BUG | Tagged , | Leave a comment