-
Our Production Database looks very slow now : This is the end of alert log. What does it tell you ?
1- Thread 1 cannot allocate new log : I know tyhis means tha log group is small, can I add two bigger log groups and not to drop the current ones
2- What this part means , this is happens trecently !! I have no idea please help ,
kccrsz: denied expansion of controlfile section 9 by 661 record(s)
the number of records is already at maximum value (65535)
krcpwnc: following controlfile record written over:
RECID #341178 Recno 21655 Record timestamp
03/12/02 11:34:40
Thread=1 Seq#=341178 Link-Recid=341177
*********************************************
Thread 1 cannot allocate new log, sequence 406713
Checkpoint not complete
Current log# 2 seq# 406712 mem# 0: E:\ORANT\DATABASE\LOGNUP2.ORA
Thread 1 advanced to log sequence 406713
Current log# 1 seq# 406713 mem# 0: D:\ORANT\DATABASE\LOGNUP1.ORA
Thread 1 cannot allocate new log, sequence 406714
Checkpoint not complete
Current log# 1 seq# 406713 mem# 0: D:\ORANT\DATABASE\LOGNUP1.ORA
kccrsz: denied expansion of controlfile section 9 by 661 record(s)
the number of records is already at maximum value (65535)
krcpwnc: following controlfile record written over:
RECID #341178 Recno 21655 Record timestamp
03/12/02 11:34:40
Thread=1 Seq#=341178 Link-Recid=341177
Low
scn: 0x0000.085f05e0
03/12/02 11:32:34
Next
scn: 0x0000.085f05fe
Thread 1 advanced to log sequence 406714
Current log# 2 seq# 406714 mem# 0: E:\ORANT\DATABASE\LOGNUP2.ORA
Thread 1 cannot allocate new log, sequence 406715
Checkpoint not complete
Current log# 2 seq# 406714 mem# 0: E:\ORANT\DATABASE\LOGNUP2.ORA
kccrsz: denied expansion of controlfile section 9 by 661 record(s)
the number of records is already at maximum value (65535)
krcpwnc: following controlfile record written over:
RECID #341179 Recno 21656 Record timestamp
03/12/02 11:34:41
Thread=1 Seq#=341179 Link-Recid=341178
Low
scn: 0x0000.085f05fe
03/12/02 11:34:40
Next
scn: 0x0000.085f0617
Thread 1 advanced to log sequence 406715
Current log# 1 seq# 406715 mem# 0: D:\ORANT\DATABASE\LOGNUP1.ORA
kccrsz: denied expansion of controlfile section 9 by 661 record(s)
the number of records is already at maximum value (65535)
krcpwnc: following controlfile record written over:
RECID #341180 Recno 21657 Record timestamp
03/12/02 11:34:42
Thread=1 Seq#=341180 Link-Recid=341179
-
THis is just a warning that the controlfile old records will be rewritten to make space for new entries, this should not be the reason for the slow down of db.
-
you can do either of the foll to supress these messages:
Set the CONTROL_FILE_RECORD_KEEP_TIME to 0:
* Insert the parameter CONTROL_FILE_RECORD_KEEP_TIME = 0 IN "INIT.ORA"
-OR-
* Set it momentarily if you cannot shut the database down now:
SQL> alter system set control_file_record_keep_time=0;
-
