Oracle Block Size VS OS Block Size
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Oracle Block Size VS OS Block Size

  1. #1
    Join Date
    Feb 2002
    Posts
    6

    Exclamation

    I have a question why it has been recommended that the Oracle Block Size must be multiple of OS Block Size. Say in some Unix Installation the O.S. Block is 512 Bytes but Oracle Default Block size comes with 2K. Multiple of OS Block Size. When OS and Oracle Transfer the Data(Or Data Exchange takes Place) it must be in terms of OS Block.
    Thanks to all of you.
    Keshav

  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092

    Yes, but say you have an OS block size of 4K. You certainly wouldn't want a db block size of 2K. You would be reading in 4K each time you requested a 2K block.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

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