50M一oracle12c数据库运行在windows2019操作系统上,最近出现几次数据库hang死,应用无法操作的情况,每次大概持续半个小时到一个小时左右,查看日志发现对应时段出现下面的日志 log1和log2(先出现log1后出现log2), Log1是怎么回事?我查了一下好像要打补丁,请问打什么补丁呢?log1和log2有关联吗? 解决log2里Checkpoint not complete的问题增大redo的大小或者增加dbwr进程数OK?谢谢!
=========================log1========================
2025-05-10T08:10:22.955187+08:00
----- PL/SQL Call Stack -----
object line object
handle number name
00007FF7CE4B8A78 259 type body SYS.WRI$_ADV_SQLTUNE.SUB_DELETE_EXECUTION
00007FF90AE905F8 2134 package body SYS.PRVT_ADVISOR.COMMON_DELETE_TASK
00007FF90AE905F8 7342 package body SYS.PRVT_ADVISOR.DELETE_EXPIRED_TASKS
00007FF8B5309780 1 anonymous block
WARNING: too many parse errors, count=300 SQL hash=0x750004bb
PARSE ERROR: ospid=12880, error=933 for statement:
2025-05-10T08:10:23.408230+08:00
DELETE FROM wri$_adv_sqlt_rtn_planWHERE task_id = :tid AND exec_name = :execution_name
Additional information: hd=00007FF8FBDFAB78 phd=00007FF7FEF0B2F8 flg=0x28 cisid=0 sid=0 ciuid=0 uid=0
2025-05-10T08:10:23.408230+08:00
----- PL/SQL Call Stack -----
object line object
handle number name
00007FF7CE4B8A78 259 type body SYS.WRI$_ADV_SQLTUNE.SUB_DELETE_EXECUTION
00007FF90AE905F8 2134 package body SYS.PRVT_ADVISOR.COMMON_DELETE_TASK
00007FF90AE905F8 7342 package body SYS.PRVT_ADVISOR.DELETE_EXPIRED_TASKS
00007FF8B5309780 1 anonymous block
2025-05-10T08:10:23.720674+08:00
WARNING: too many parse errors, count=400 SQL hash=0x750004bb
PARSE ERROR: ospid=12880, error=933 for statement:
2025-05-10T08:10:23.720674+08:00
DELETE FROM wri$_adv_sqlt_rtn_planWHERE task_id = :tid AND exec_name = :execution_name
Additional information: hd=00007FF8FBDFAB78 phd=00007FF7FEF0B2F8 flg=0x28 cisid=0 sid=0 ciuid=0 uid=0
===========================Log2======================
2025-05-10T09:04:52.388403+08:00
Archived Log entry 46544 added for T-1.S-46571 ID 0x8244f60f LAD:1
2025-05-10T09:05:19.289742+08:00
Thread 1 cannot allocate new log, sequence 46573
Checkpoint not complete
Current log# 3 seq# 46572 mem# 0: E:\ORADATA\PAY\REDO03.LOG
2025-05-10T09:05:26.928971+08:00
Thread 1 advanced to log sequence 46573 (LGWR switch)
Current log# 1 seq# 46573 mem# 0: E:\ORADATA\PAY\REDO01.LOG
2025-05-10T09:05:31.740594+08:00
Archived Log entry 46545 added for T-1.S-46572 ID 0x8244f60f LAD:1
2025-05-10T09:05:46.362922+08:00
Thread 1 cannot allocate new log, sequence 46574
Checkpoint not complete
墨值悬赏

评论

