DBA Test

[chensun]

Q. 5 : In case of heavy contention for latches, set the LOG_SIMULTANEOUS_COPIES initialization parameter to

1. Twice the number of CPUs
2. Same as the DB Block Buffers
3. Same as the Shared Pool Size
4. None of the above


what the ans is 1? can someone tell me why?

[padmam]

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]

[padmam]

Dear PANDU,UDAY

Some times i post a thread it shows Priew the post and it Gets twice posted could you kindly look in to the trouble or advice me reg this.

Alos let me know how to view the threads which i have posted till date as a consolidates.

Cheers

Padmam

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

[sreddy]

Try submitting only once which resolves the problem of duplicating the post.

Search on your name, which gives the all threads you participated till now.

[padmam]

Hi, 25th April 2001 19:29 hrs chennai

Thank you very Much.

Cheers

Padmam

[chensun]

Thank You very much for everybody, as your ans is helpful to me!