what's db_block_size if it's not configured at all in init.ora ?? - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 16 of 16

Thread: what's db_block_size if it's not configured at all in init.ora ??

  1. #11
    Join Date
    Jul 2001
    Location
    Singapore(Asia)-WebCentre business company
    Posts
    456
    hi hrishy,

    actually my original qn is if we dont specify any db_block_size in init.ora does this mean ORacle will take the lowest value of 2048 as the default blocksize or is it pluck somewhere from the OS parameter block size?

  2. #12
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    Yes it will pick the lowest for that particular operating system

    regards
    Hrishy

  3. #13
    Join Date
    Jul 2001
    Location
    Singapore(Asia)-WebCentre business company
    Posts
    456
    hrishy,

    thank-u that's the reply I hope to get.

  4. #14
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    and I wonder who on earth dont specify block size when they create a database? are we using SQL Server?

  5. #15
    Join Date
    Feb 2002
    Posts
    267
    Hi folks,

    When oracle says, your db_block_size should be the multiple of OS block size, are they refrrring to the OS block size at the finest level ie., ( eg..512bytes) or the file system block size.

    Well the file system block size can be found by
    # fstyp v /dev/dsk/c0d0s0 | grep size

    I was always under the impression, that it was file system block size.
    Could somebody clarify this.
    Regards
    sonia

  6. #16
    Join Date
    Jan 2001
    Posts
    2,828
    Hi Sonia

    The os block size is not relevant..for most of ORACLE its the file system block size..the db block size should be atleast equal to the file system block size..i.e df -g output as shown in the thread

    regards
    Hrishy

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