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

Thread: Log_buffer

  1. #1
    Join Date
    Feb 2002
    Posts
    267
    Hi,
    How to size log buffer cache....

    The parameter log_buffer doesn't seem to be have any effect on the size on the log buffer cache...
    Wht for is this parameter log_buffer is ?


    regards
    sonia

  2. #2
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    What Oracle version, because on 8.1.7 is does... and I'm pretty sure it's the same for 9.2.
    OCP 8i, 9i DBA
    Brisbane Australia

  3. #3
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    I think it is same from Oracle 7 to 9i.
    You may be missing something, make sure you are editing the correct init.ora file.

    Sanjay

  4. #4
    Join Date
    Feb 2002
    Posts
    267
    hi,
    it is 8.1.7...
    Wht does this parameter specify...log_buffer
    and why this value shoud be a multiple of 512k...

  5. #5
    Join Date
    Apr 2002
    Posts
    135
    LOG_BUFFER specifies the amount of memory, in bytes, that Oracle uses when buffering redo entries to a redo log file. Redo log entries contain a record of the changes that have been made to the database block buffers. The LGWR process writes redo log entries from the log buffer to a redo log file.

    In general, larger values for LOG_BUFFER reduce redo log file I/O, particularly if transactions are long or numerous.

    If the 'redo log space requests' statistic in V$SYSSTAT is non-zero, you should increase LOG BUFFER.

    SELECT name, value
    FROM V$SYSSTAT where name ='redo log space requests';

    A good starting point for the log_buffer is 64K, there is generally no advantage in making the log_buffer larger than 1 Mb.

    VALUE: Maximum is 512 KB or 128 KB * CPU_COUNT, whichever is greater.




    [Edited by sona on 08-22-2002 at 01:29 AM]

  6. #6
    Join Date
    Jun 2002
    Posts
    73
    I don't know why its not effecting your log buffer size..the only parameter is LOG_BUFFER and be sure to edit the correct init.ora file.
    You cannot succeed if you fear to face challenges.
    MAS
    BE(CS) , OCP 8/8i.



  7. #7
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    if you are using 9.2 and your database creation is all by default then most probably is you are using spfile so editing init.ora is not enough

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