Oracle alert文件分析(七)

2014-11-24 16:51:55 · 作者: · 浏览: 5
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:14090364.
DIA0 successfully resolved a LOCAL, HIGH confidence hang with ID=91.
2013-05-20 07:56:20.801000 +08:00
Errors in file /u01/app/oracle/diag/rdbms/tlodb/tlodb1/trace/tlodb1_dia0_6423436.trc (incident=80062):
ORA-32701: Possible hangs up to hang ID=99 detected
2013-05-20 07:56:36.080000 +08:00
DIA0 terminating blocker (ospid: 11731582 sid: 724 ser#: 3) of hang with ID = 94
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:11731582.
DIA0 successfully resolved a LOCAL, HIGH confidence hang with ID=94.
2013-05-20 07:56:38.252000 +08:00
Sweep [inc][80062]: completed
2013-05-20 07:56:51.149000 +08:00
DIA0 terminating blocker (ospid: 13566860 sid: 1504 ser#: 317) of hang with ID = 95
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:13566860.
DIA0 successfully resolved a LOCAL, HIGH confidence hang with ID=95.
2013-05-20 07:56:54.213000 +08:00
Errors in file /u01/app/oracle/diag/rdbms/tlodb/tlodb1/trace/tlodb1_dia0_6423436.trc (incident=80063):
ORA-32701: Possible hangs up to hang ID=99 detected
2013-05-20 07:57:09.300000 +08:00
DIA0 terminating blocker (ospid: 8127290 sid: 582 ser#: 1) of hang with ID = 97
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:8127290.
DIA0 successfully resolved a LOCAL, HIGH confidence hang with ID=97.
2013-05-20 07:57:24.359000 +08:00
DIA0 terminating blocker (ospid: 12714600 sid: 921 ser#: 445) of hang with ID = 98
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:12714600.
DIA0 successfully resolved a LOCAL, HIGH confidence hang with ID=98.
2013-05-20 07:57:27.450000 +08:00
Errors in file /u01/app/oracle/diag/rdbms/tlodb/tlodb1/trace/tlodb1_dia0_6423436.trc (incident=80064):
ORA-32701: Possible hangs up to hang ID=99 detected
2013-05-20 07:57:42.537000 +08:00
DIA0 terminating blocker (ospid: 12452844 sid: 1044 ser#: 12845) of hang with ID = 99
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 resol