Hi, 25th April 2001 9:46 hrs chennai

To reduce the contention for latches.

You have to inrease the LOG_SIMULTANEOUS_COPIES
Decrease the LOG_SMALL_ENTRY_MAX_SIZE

The reason for increasing LOG_SIMULTANEOUS_COPIES
====================================
By increasing the LOG_SIMULTANEOUS_COPIES

the number of redo copy latches are increased.
The max number of redo copy latches is
2* Number of CPU's.

Even with one CPU ,this may be beneficial because CPU resource can be optimized.Increasing the number of copy latches ensures that a process has a better chance of obtaining a copy latch if needed.

Cheers

Padmam






[Edited by padmam on 04-25-2001 at 12:49 AM]