11gR1
OL6
Hi ALL,
I am running command > alter system switch logfile;
But it took like 15 minutes to complete? What is causing this long?
I check the alert log and it displays message below:
Sat Jan 06 00:15:24 2018
Beginning log switch checkpoint up to RBA [0x466.2.10], SCN: 5966848405174
Thread 1 advanced to log sequence 1126 (LGWR switch)
Current log# 2 seq# 1126 mem# 0: /u01/oracle/PROD/db/apps_st/data/log02a.dbf
Current log# 2 seq# 1126 mem# 1: /u01/oracle/PROD/db/apps_st/data/log02b.dbf
Thread 1 cannot allocate new log, sequence 1127
Checkpoint not complete
Current log# 2 seq# 1126 mem# 0: /u01/oracle/PROD/db/apps_st/data/log02a.dbf
Current log# 2 seq# 1126 mem# 1: /u01/oracle/PROD/db/apps_st/data/log02b.dbf
Sat Jan 06 00:24:45 2018
Incremental checkpoint up to RBA [0x465.3a12.0], current log tail at RBA [0x466.10e57.0]
Sat Jan 06 00:26:45 2018
Completed checkpoint up to RBA [0x466.2.10], SCN: 5966848405174
Sat Jan 06 00:26:46 2018
Thread 1 cannot allocate new log, sequence 1127
Private strand flush not complete
Current log# 2 seq# 1126 mem# 0: /u01/oracle/PROD/db/apps_st/data/log02a.dbf
Current log# 2 seq# 1126 mem# 1: /u01/oracle/PROD/db/apps_st/data/log02b.dbf
Beginning log switch checkpoint up to RBA [0x467.2.10], SCN: 5966848439347
Thread 1 advanced to log sequence 1127 (LGWR switch)
Current log# 1 seq# 1127 mem# 0: /u01/oracle/PROD/db/apps_st/data/log01a.dbf
Current log# 1 seq# 1127 mem# 1: /u01/oracle/PROD/db/apps_st/data/log01b.dbf
Sat Jan 06 00:32:27 2018
Completed checkpoint up to RBA [0x467.2.10], SCN: 5966848439347
How do you speedup switching of logfiles?
Kind regards,
jc