Oracle alert文件分析(九)
/rdbms/tlodb/tlodb1/trace/tlodb1_dia0_6423436.trc (incident=80069):
ORA-32701: Possible hangs up to hang ID=122 detected
2013-05-20 08:20:24.239000 +08:00
DIA0 terminating blocker (ospid: 8323632 sid: 1441 ser#: 1) of hang with ID = 119
requested by master DIA0 process on instance 1
Hang Resolution Reason: Although the number of affected sessions did not
justify automatic hang resolution initially, this previously ignored
hang was automatically resolved.
by terminating the process
DIA0 successfully terminated process ospid:8323632.
DIA0 successfully resolved a LOCAL, HIGH confidence hang with ID=119.
2013-05-20 08:20:39.549000 +08:00
Errors in file /u01/app/oracle/diag/rdbms/tlodb/tlodb1/trace/tlodb1_dia0_6423436.trc (incident=80070):
ORA-32701: Possible hangs up to hang ID=122 detected
2013-05-20 08:20:54.619000 +08:00
DIA0 terminating blocker (ospid: 9634296 sid: 1022 ser#: 1) of hang with ID = 120
requested by master DIA0 process on instance 1
Hang Resolution Reason: Although hangs of this root type are typically
self-resolving, the previously ignored hang was automatically resolved.
by terminating the process
DIA0 successfully terminated process ospid:9634296.
DIA0 successfully resolved a LOCAL, HIGH confidence hang with ID=120.
2013-05-20 08:22:29.126000 +08:00
Sweep [inc][80070]: completed
Sweep [inc][80069]: completed
Sweep [inc][80068]: completed
Sweep [inc][80067]: completed
Sweep [inc][80066]: completed
2013-05-20 08:28:20.280000 +08:00
>>> WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=220
System State dumped to trace file /u01/app/oracle/diag/rdbms/tlodb/tlodb1/trace/tlodb1_j004_10093488.trc
2013-05-20 08:28:27.184000 +08:00
>>> WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=219
2013-05-20 08:39:28.521000 +08:00
Errors in file /u01/app/oracle/diag/rdbms/tlodb/tlodb1/trace/tlodb1_dia0_6423436.trc (incident=80071):
ORA-32701: Possible hangs up to hang ID=128 detected
2013-05-20 08:39:43.596000 +08:00
DIA0 terminating blocker (ospid: 14484116 sid: 644 ser#: 859) of hang with ID = 123
requested by master DIA0 process on instance 1
Hang Resolution Reason: Automatic hang resolution was performed to free a
significant number of affected sessions.
by terminating session sid: 644 ospid: 14484116
2013-05-20 08:39:47.762000 +08:00
DIA0 successfully terminated session sid:644 ospid:14484116 with status 31.
System State dumped to trace file /u01/app/oracle/diag/rdbms/tlodb/tlodb1/trace/tlodb1_j004_10093488.trc
2013-05-20 08:28:27.184000 +08:00
>>> WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! pid=219
2013-05-20 08:39:28.521000 +08:00
Errors in file /u01/app/oracle/diag/rdbms/tlodb/tlodb1/trace/tlodb1_dia0_6423436.trc (incident=80071):
ORA-32701: Possible hangs up to hang ID=128 detected
2013-05-20 08:39:43.596000 +08:00
DIA0 terminating blocker (ospid: 14484116 sid: 644 ser#: 859) of hang with ID = 123
requested by master DIA0 process on instance 1
Hang Resolution Reason: Automatic hang resolution was performed to free a
significant number of affected sessions.
by terminating session sid: 644 ospid: 14484116
2013-05-20 08:39:47.762000 +08:00
DIA0 successfully terminated session sid:644 ospid:14484116 with status 3