Weekend June 9, 2013
Dbms: Oracle11.1.0.7 4 nodes RAC
Reporting extremely slow System Operation
Check the system wait event. The following statements are added to the backlog:
View
Insert into counterloadmessage (emsid, period, period, moentityid, startday, starttime, period, period, indicatortable, filename, succnum, failnum, loadstate, inserttime, taskid, interval, insertseq) select: 1 as emsid,: 2 as emsentityid, t1.equipmentid as equipmentid, t2.moentityid as moentityid,: 3 as startday,: 4 as starttime,: 5 as period,: 6 as indicatorsetid ,: 7 as indicatortable,: 8 as filename,: 9 as succnum,: 10 as failnum,: 11 as loadstate, to_char (sysdate-to_date ('2017-01-01 00:00:00 ', 'yyyy-mm-dd hh24: mi: ss') * 60*60*24*1000 + to_number (to_char (systimestamp, 'ff3') as inserttime ,: 12 as taskid, to_char (sysdate, 'yyyy-mm-dd hh24: mi: ss'), SEQ_COUNTERLOADMESSAGE.NEXTVAL from pm4h_ad.cm_equipment t1, pm4h_ad.mo_moentity t2, pm4h_ad.mdl_motype t3 where t1.motypeid = t2.motypeid and t2.motypeid = t3.motypeid and t3.iscommon = 0 and t2.moentitycode =: 13
The main wait event is enq: TX-index contention. This is a common SQL statement that runs 1.5 s on average once.
Other nodes have no load.
View the alter log
Errors in file/opt/oracle/diag/rdbms/mos5200/mos52001/trace/mos52001_ora_19284.trc (incident = 250211 ):
ORA-00600: internal error code, arguments: [], [], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kclcls_8], [1091616], [], [], [], [], [], [], [], [], []
Incident details in:/opt/oracle/diag/rdbms/mos5200/mos52001/incident/incdir_250211/mos52001_ora_19284_i250211.trc
Trace dumping is refreshing Ming id = [cdmp_20130609064529]
Sun Jun 09 06:45:30 2013
Found Dali ora-600 error, metalink can not find related bugs.
Solution: restart all rac nodes. The system is normal.
If a friend of the same person finds the related solution, please submit it and provide a temporary solution for the friend who has encountered the problem. Restart.