DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: DBA Test

  1. #1
    Join Date
    Apr 2001
    Posts
    7
    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?

  2. #2
    Join Date
    Mar 2000
    Location
    Chennai.Tamilnadu.India.
    Posts
    658

    Latches-contention

    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]
    Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it

  3. #3
    Join Date
    Mar 2000
    Location
    Chennai.Tamilnadu.India.
    Posts
    658

    UDAY,PANDU

    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]
    Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it

  4. #4
    Join Date
    Feb 2000
    Location
    Washington DC
    Posts
    1,843

    padmam,

    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.
    Reddy,Sam

  5. #5
    Join Date
    Mar 2000
    Location
    Chennai.Tamilnadu.India.
    Posts
    658

    Re: Thanks a Lot

    Hi, 25th April 2001 19:29 hrs chennai

    Thank you very Much.

    Cheers

    Padmam
    Attitude:Attack every problem with enthusiasam ...as if your survival depends upon it

  6. #6
    Join Date
    Apr 2001
    Posts
    7
    Thank You very much for everybody, as your ans is helpful to me!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width