Changing the size of log_buffer
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Changing the size of log_buffer

  1. #1
    Join Date
    Sep 2006
    Posts
    114

    Changing the size of log_buffer

    I am using 10g on win2000 for testing purpose
    and i am changing the log_buffer

    SQL> show parameter log_buffer;

    NAME TYPE VALUE
    ------------------------------------ ----------- -----------
    log_buffer integer 11158528

    SQL> alter system set log_buffer=5242880 scope=spfile;

    System altered.

    SQL> shutdown immediate
    Database closed.
    Database dismounted.
    ORACLE instance shut down.
    SQL> startup
    ORACLE instance started.

    Total System Global Area 138412032 bytes
    Fixed Size 1247756 bytes
    Variable Size 75498996 bytes
    Database Buffers 54525952 bytes
    Redo Buffers 7139328 bytes
    Database mounted.
    Database opened.
    SQL> show parameter log_buffer

    NAME TYPE VALUE
    ------------------------------------ ----------- -----------
    log_buffer integer 7028736

    I have changed log_buffer from 11158528 to 5242880
    But when i restart the DB then i found log_buffer=7028736 instead of specified value(524288)
    granule_size=4MB
    What could be the reason?
    Can anybody help me in this regard?

    thanx in advance

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    the database will round things to the apprpriate level, thats all its doing

  3. #3
    Join Date
    Sep 2006
    Posts
    114
    Quote Originally Posted by davey23uk
    the database will round things to the apprpriate level, thats all its doing
    thanx for ur prompt response but can u please give me more explanation
    i hope u wont mind it
    anyhow thanx a lot

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