Dear all,
After four Oracle 10 upgrades, the only remaining warning I have on db13 in all databases I upgraded is about "checkpoint not complete" . This only happens when there is a lot of activity in the database . It never happened before though, even when there was a lot of activity in the database.
I found note #79341 and #1068186 and I have set DISABLESELFTUNE_CHECKPOINTING
to FALSE, but this didn't particularly help, still get the warnings
My questions are:
The log buffer size is increased by the upgrade to 14M (instead of 1M that is used to be). I have 2 groups of redo log files, with 2 files each. Each file is 20M on size.
I was thinking of increasing them to 30M each. Do you think that this is a good thing to do?
Under /oracle/SID/saptrace/background, I see in the log writer trace the messages below. Do you know why I get these messages and are they relevant to the issue I have with the checkpoint?
Maximum redo generation record size = 197120 bytes
Maximum redo generation change vector size = 190204 bytes
tkcrrsarc: (WARN) Failed to find ARCH for message (message:0x10)
tkcrrpa: (WARN) Failed initial attempt to send ARCH message (message:0x10)
LGWR: Archivelog for thread 1 sequence 3662 will NOT be compressed
LGWR: Archivelog for thread 1 sequence 3663 will NOT be compressed
LGWR: Archivelog for thread 1 sequence 3664 will NOT be compressed
Many thanks
Andreas
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.