General Question
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: General Question

  1. #1
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727

    Post LOG_SIMULTANEOUS_COPIES

    In case of heavy contention for latches, set the LOG_SIMULTANEOUS_COPIES initialization parameter to
    Twice the number of CPUs

    1. What is meant by "Heavy contention of latches"
    2. What is the use of of the parameter LOG_SIMULTANEOUS_COPIES


  2. #2
    Join Date
    Feb 2001
    Location
    Bombay,India
    Posts
    530

    Re: LOG_SIMULTANEOUS_COPIES

    Hi,

    LOG_SIMULTANEOUS_COPIES specifies the maximum number of redo buffer copy latches available to write log entries simultaneously. For good performance, you can have up to twice as many redo copy latches as CPUs. For a single-processor system, set to zero so that all log entries are copied on the redo allocation latch
    In Oracle,if a process wants to write anything into the SGA it has to acquire a latch.So if LGWR wants to write to redo log files it has to acquire a latch so that no other process makes changes to that part when it is copying.
    In case of any help please be free to write to me at rohitsn@altavista.com

    Regards,
    Rohit Nirkhe,Oracle DBA,OCP 8i

  3. #3
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    Hi..

    Thanks Rhit. Will you please explain the term Latches..? Is it buffers itself?

    Thanks

    Thomas
    royxavier@yahoo.com

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

    Solution

    Hi, 25th April 2001 13:28 hrs chennai

    Latches are not buffers.It is a used to protect access to internal structures.

    A process which needs to change this structures first need latches to acuire.

    latches are held by them till it has finished its task.

    Most cases of latch contention occur when two or more process concurrently attempt to btain the same latch.This rarely occurs on a single CPU computers where only single process can be active at once.

    You can use v$latch and v$latchname to query the statistics.

    The LOG_SIMULTANEOUS_COPIES should be always twice the number of CPU's

    Cheers

    Padmam

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

  5. #5
    Join Date
    Apr 2001
    Location
    Bangalore, India
    Posts
    727
    Thanks Padmam

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