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

Thread: DBWR internal write batch size

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

    DBWR internal write batch size

    Hi mates!

    I have to set the parameter db_file_simultaneously_writes. This parameter is influceing the DBWR internal write batch size. The write batch size is calculated from the smallest value of the following

    1. (db_files * db_file_simultaneous_writes)/2 or
    2. 1/4 of the db_block_buffers or
    3. Platform specific value for the internal write batch size.

    Now, I have no idea what is the platform specific DBWR write batch size for Sun Solaris 8 with oracle 7.3.4 (I know this is an odd combination.. what to do..! Application wants it!!) and oracle 8i? Anybody know this value?

    I appreciate your help!

    Thanks
    Thomas Saviour(royxavier@yahoo.com)
    Technical Lead (Databases)
    Thomson Reuters (Markets)

    http://ora600tom.wordpress.com/

  2. #2
    Join Date
    Nov 1999
    Location
    Kuwait
    Posts
    122

    Wink

    Dude check this out hope it will help you

    http://download-east.oracle.com/docs/pdf/A85471_01.pdf


    Regards,
    NK
    ====================================================
    Stand up for your principles even if you stand alone!
    ====================================================

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