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

Thread: Oracle Block Size VS OS Block Size

  1. 02-11-2002, 07:58 AM #1
    keshav_trip
    keshav_trip is offline Junior Member
    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
    Reply With Quote Reply With Quote
  2. 02-11-2002, 10:34 AM #2
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width