| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Checkpoint not complete
A copy of this was sent to "Pedro Tavares" <pedrotavares_at_cmvm.pt>
(if that email address didn't require changing)
On Mon, 4 Jan 1999 17:02:45 -0000, you wrote:
>My database has lots of activity, and if I monitor de alert log, I'm
>constantly receiving the message - checkpoint not complete. I believe that
>this is affecting the overall performance. What can I do to avoid this? I
>have 4 redo log files of 1M each.
>Thanks in advance.
>
>Pedro Tavares
>Lisbon, Portugal
>
Add more redo. This message means that by the time we've gone through 4 1m redo log files, the checkpoint that was started by switching from log 1 to log 2 has not compleleted yet. We need to STOP and finish the checkpoint before we can do anymore work.
On a modestly sized system (about 6 gig of data, generates about 2-3gig of online redo per week) we run with 3x25meg log files (multiplexed as well for a total of 150meg of log) without hitting the 'checkpoint not complete'. Your mileage will vary -- you want enough online redo log to carry you through the busy times, giving the system enough time to checkpoint in the background without stopping everything...
Thomas Kyte
tkyte_at_us.oracle.com
Oracle Service Industries
Reston, VA USA
--
http://govt.us.oracle.com/ -- downloadable utilities
Anti-Anti Spam Msg: if you want an answer emailed to you, you have to make it easy to get email to you. Any bounced email will be treated the same way i treat SPAM-- I delete it. Received on Mon Jan 04 1999 - 12:26:37 CST
 |
 |