Oracle alert文件分析(八)
ved.
by terminating the process
DIA0 successfully terminated process ospid:12452844.
DIA0 successfully resolved a LOCAL, HIGH confidence hang with ID=99.
2013-05-20 08:02:22.532000 +08:00
Sweep [inc][80064]: completed
Sweep [inc][80063]: completed
2013-05-20 08:16:58.068000 +08:00
Errors in file /u01/app/oracle/diag/rdbms/tlodb/tlodb1/trace/tlodb1_dia0_6423436.trc (incident=80065):
ORA-32701: Possible hangs up to hang ID=122 detected
2013-05-20 08:17:02.744000 +08:00
Sweep [inc][80065]: completed
2013-05-20 08:17:13.145000 +08:00
DIA0 terminating blocker (ospid: 18743428 sid: 903 ser#: 7) of hang with ID = 122
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: 903 ospid: 18743428
2013-05-20 08:17:17.434000 +08:00
DIA0 successfully terminated session sid:903 ospid:18743428 with status 31.
DIA0 successfully resolved a LOCAL, HIGH confidence hang with ID=122.
2013-05-20 08:18:14.658000 +08:00
Errors in file /u01/app/oracle/diag/rdbms/tlodb/tlodb1/trace/tlodb1_dia0_6423436.trc (incident=80066):
ORA-32701: Possible hangs up to hang ID=122 detected
2013-05-20 08:18:29.724000 +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 session sid: 1441 ospid: 8323632
2013-05-20 08:18:34.669000 +08:00
DIA0 successfully terminated session sid:1441 ospid:8323632 with status 31.
DIA0 successfully resolved a LOCAL, HIGH confidence hang with ID=119.
2013-05-20 08:18:44.929000 +08:00
Errors in file /u01/app/oracle/diag/rdbms/tlodb/tlodb1/trace/tlodb1_dia0_6423436.trc (incident=80067):
ORA-32701: Possible hangs up to hang ID=122 detected
2013-05-20 08:19:00.005000 +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 session sid: 1022 ospid: 9634296
2013-05-20 08:19:04.669000 +08:00
DIA0 successfully terminated session sid:1022 ospid:9634296 with status 31.
DIA0 successfully resolved a LOCAL, HIGH confidence hang with ID=120.
2013-05-20 08:19:07.736000 +08:00
Errors in file /u01/app/oracle/diag/rdbms/tlodb/tlodb1/trace/tlodb1_dia0_6423436.trc (incident=80068):
ORA-32701: Possible hangs up to hang ID=122 detected
2013-05-20 08:19:22.802000 +08:00
DIA0 terminating blocker (ospid: 18743428 sid: 903 ser#: 7) of hang with ID = 122
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 the process
DIA0 successfully terminated process ospid:18743428.
DIA0 successfully resolved a LOCAL, HIGH confidence hang with ID=122.
2013-05-20 08:20:09.176000 +08:00
Errors in file /u01/app/oracle/diag