RAC 节点报错ORA-07445 [pevm_icd_call_common()+225] [SIGSEGV] [ADDR:0x0] [PC:...

windjack

在ORACLE 19.9 RAC节点中频繁报错如下：

2020-12-08T20:14:37.416774+08:00
Exception [type: SIGSEGV, SI_KERNEL(general_protection)] [ADDR:0x0] [PC:0x1289D861, pevm_icd_call_common()+225] [flags: 0x0, count: 1]
Errors in file /u01/app/oracle/diag/rdbms/jbzyydb/jbzyydb2/trace/jbzyydb2_m004_48783.trc  (incident=196621):
ORA-07445: exception encountered: core dump [pevm_icd_call_common()+225] [SIGSEGV] [ADDR:0x0] [PC:0x1289D861] [SI_KERNEL(general_protection)] []
Use ADRCI or Support Workbench to package the incident.
See  Note 411.1   at My Oracle Support for error and packaging details.
2020-12-08T20:15:37.532290+08:00
Exception [type: SIGSEGV, SI_KERNEL(general_protection)] [ADDR:0x0] [PC:0x1289D861, pevm_icd_call_common()+225] [flags: 0x0, count: 1]
Errors in file /u01/app/oracle/diag/rdbms/jbzyydb/jbzyydb2/trace/jbzyydb2_m003_46441.trc  (incident=196387):
ORA-07445: exception encountered: core dump [pevm_icd_call_common()+225] [SIGSEGV] [ADDR:0x0] [PC:0x1289D861] [SI_KERNEL(general_protection)] []
Use ADRCI or Support Workbench to package the incident.
See  Note 411.1   at My Oracle Support for error and packaging details.
2020-12-08T20:16:37.632317+08:00
Exception [type: SIGSEGV, SI_KERNEL(general_protection)] [ADDR:0x0] [PC:0x1289D861, pevm_icd_call_common()+225] [flags: 0x0, count: 1]
Errors in file /u01/app/oracle/diag/rdbms/jbzyydb/jbzyydb2/trace/jbzyydb2_m002_50676.trc  (incident=197173):
ORA-07445: exception encountered: core dump [pevm_icd_call_common()+225] [SIGSEGV] [ADDR:0x0] [PC:0x1289D861] [SI_KERNEL(general_protection)] []
Use ADRCI or Support Workbench to package the incident.
See  Note 411.1   at My Oracle Support for error and packaging details.
2020-12-08T20:17:20.400319+08:00






根据trace记录，错误出在(Automatic Report Flush) 操作。
       这个功能的作用和影响是 :
There is a new feature in 12C called "Automatic Report Capturing Feature". As part of this feature, some monitoring SQLs are executed by MMON_SLAVE to identify the resource-intensive SQLs and generate the SQL Monitoring report automatically for those SQLs. Those SQLs consume little more CPU and it is expected behavior being a new feature. Such monitoring queries can be identified from (G)V$SQLSTATS.
However, If the CPU consumption is significantly high then it is not an expected behavior and could be due to optimizer choosing suboptimal plan for the SQL statements.
     有时候它会触发一些问题，比如
ORA-12850 is Raised by Mmon Slave Automatic Report Flush Action ( Doc ID 2217969.1  )
High CPU Usage and/or Frequent Occurrences of ORA-12850 or ORA-12751 For Monitor Queries by MMON From 12.1 ( Doc ID 2102131.1  )
  
      您可以直接关闭这个新特性来规避错误
SQL> alter system set "_report_capture_cycle_time"=0;