Thu Aug 29 16:38:26 2024
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_dia0_5479.trc (incident=168083):
ORA-32701: Possible hangs up to hang ID=47 detected
Incident details in: /u01/app/oracle/diag/rdbms/orcl/orcl1/incident/incdir_168083/orcl1_dia0_5479_i168083.trc
DIA0 terminating blocker (ospid: 34971 sid: 780 ser#: 36561) of hang with ID = 47
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:780 with serial # 36561 (ospid:34971)
Thu Aug 29 16:38:27 2024
Sweep [inc][168083]: completed
Sweep [inc2][168083]: completed
DIA0 successfully terminated session sid:780 with serial # 36561 (ospid:34971) with status 31.
DIA0 successfully resolved a GLOBAL, HIGH confidence hang with ID=47.
Thu Aug 29 16:40:01 2024
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_dia0_5479.trc (incident=168084):
ORA-32701: Possible hangs up to hang ID=47 detected
Incident details in: /u01/app/oracle/diag/rdbms/orcl/orcl1/incident/incdir_168084/orcl1_dia0_5479_i168084.trc
DIA0 terminating blocker (ospid: 34971 sid: 780 ser#: 36561) of hang with ID = 47
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 ospid:34971
DIA0 successfully terminated process ospid:34971.
DIA0 successfully resolved a GLOBAL, HIGH confidence hang with ID=47.
Thu Aug 29 17:39:58 2024
Errors in file /u01/app/oracle/diag/rdbms/orcl/orcl1/trace/orcl1_dia0_5479.trc (incident=168086):
ORA-32701: Possible hangs up to hang ID=48 detected
Incident details in: /u01/app/oracle/diag/rdbms/orcl/orcl1/incident/incdir_168086/orcl1_dia0_5479_i168086.trc
DIA0 terminating blocker (ospid: 767 sid: 507 ser#: 27073) of hang with ID = 48
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 ospid:767
DIA0 successfully terminated process ospid:767.
DIA0 successfully resolved a GLOBAL, HIGH confidence hang with ID=48.
处理办法-持续观察
alter system set result_cache_max_size=0;
文档:Error 'ORA-32701: Possible hangs up to hang ID= detected' with Result Cache Enabled (Doc ID 2411537.1)