这些日志是切换日志信息，没有问题。
报表特别慢，增加redo数量/调整redo大小试试。这个库里面才3个50M的redo文件，另外sga才200多M看下系统还有内存不，增加sga。
e:\oracle\product\10.2.0\admin\bms\udump\bms_ora_1612.trc 这个trc贴出来看看
评论
有用 0
这些日志有问题吗？
Thread 1 advanced to log sequence 2233
Current log# 3 seq# 2233 mem# 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\BMS\REDO03.LOG
Wed Sep 14 04:22:03 2022
Thread 1 advanced to log sequence 2234
Current log# 1 seq# 2234 mem# 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\BMS\REDO01.LOG
Wed Sep 14 22:00:07 2022
Thread 1 advanced to log sequence 2235
Current log# 2 seq# 2235 mem# 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\BMS\REDO02.LOG
Thu Sep 15 11:09:05 2022
Thread 1 advanced to log sequence 2236
Current log# 3 seq# 2236 mem# 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\BMS\REDO03.LOG
Fri Sep 16 02:17:46 2022
Thread 1 advanced to log sequence 2237
Current log# 1 seq# 2237 mem# 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\BMS\REDO01.LOG
Fri Sep 16 17:01:01 2022
Thread 1 advanced to log sequence 2238
Current log# 2 seq# 2238 mem# 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\BMS\REDO02.LOG
Sat Sep 17 06:00:07 2022
Thread 1 advanced to log sequence 2239
Current log# 3 seq# 2239 mem# 0: E:\ORACLE\PRODUCT\10.2.0\ORADATA\BMS\REDO03.LOG
Sat Sep 17 17:40:49 2022
评论 有用 0
