library cache lock和cursor: mutex S常见原因

造成library cache lock的常见原因：

1、回收站oracle recyclebin

2、重建索引

3、收集数据库统计信息

4、11g密码延迟特性

 

 

cursor: mutex S、kksfbc child completion、library cache lock造成数据库cpu100%

触发Oracle的bug：10636231

 

解决方案：

版本11.1.0.7
SQL> alter system set "_cursor_features_enabled"=18 scope=spfile;
System altered.
SQL> alter system set event='106001 trace name context forever,level 1024' scope=spfile;
System altered.
并重启实例

版本11.2.0.1
SQL> alter system set "_cursor_features_enabled"=34 scope=spfile;
System altered.
SQL> alter system set event='106001 trace name context forever,level 1024' scope=spfile;
System altered.

版本11.2.0.2
SQL> alter system set "_cursor_features_enabled"=1026 scope=spfile;
System altered.
SQL> alter system set event='106001 trace name context forever,level 1024' scope=spfile;
System altered.

版本11.2.0.3+
alter system set "_cursor_obsolete_threshold"=1024 scope=spfile;