CHECKPOINTS

We have a problem with redo log switching when running large jobs. All groups fill up and remain active even though they
are archived - presumably this is because checkpointing is going on.

Finally when the
last log group fills and wants to switch back to the first group it cannot do so, because the first group is still active. At this point the system slows to a crawl and even trivial queries require minutes for a response.

We have
increased the number of redo log groups
(almost doubling the space available),
and have also increased the initialization parameter db_block_checkpoint_batch
so as to allow for faster checkpointing. Yet the problem persists.

Does anyone have any pointers for us?

Is there any good documentation on how the checkpoint process works and why it takes so long?

Our System
Oracle V7.3.4, RS/6000, 2CPUs, 1.3 GB Memory, AIX

Thanks in advance,
Mario Received on Wed Mar 01 2000 - 00:00:00 CST