OS Block Size
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: OS Block Size

  1. #1
    Join Date
    Apr 2001
    Posts
    47
    Hi everyone,

    We are planning for a large OLTP database. When issues has been analyzed there is a serious discussion on changing the SUN OS default block size 512k to 2k (or) 4k.

    We know INIT parmeter setings for oracle will do for the db_block_size. And it should be in multiples of OS Blocks

    But we would like to know whether changing of OS default block size is recommended or not. Kindly experienced people suggest the pros and cons of the same in this issue


  2. #2
    Join Date
    Feb 2001
    Location
    Paris, France
    Posts
    809
    I do not have personnaly any experience on changing the OS block size, but I've been working for long on Ux boxes, and always had good performances, if the Oracle block size is chosen correctly of course ...

  3. #3
    Join Date
    Jan 2001
    Posts
    2,828
    hi

    i n case ur databse is OLTP then it is better to have a block size like 4K to 8K i will prefer 8K atleast and dont forget to make ur db_block_size=multiple of os block size as that would ensure you that in a single i/o oracle can fetch atleast 8k of data.improving your i/o

    regards
    hrishy

  4. #4
    Join Date
    Apr 2001
    Posts
    47
    Hi

    Thanx,

    I relatedly want to know the impact of changing the default of block size. What are its pros and cons.


    It would be much helpful for me and that's the one which I really need

  5. #5
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    IMO, what matters more is the Oracle block size, not the OS block size.

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