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

Thread: ntfs block size

  1. #1
    Join Date
    Nov 2000
    Posts
    440

    ntfs block size

    We have a new server and we are installing windows 2000.
    I need to know what ntfs block size should i put, any idea?

    My database is a oltp environnement, the actual db_block_size we are using is 8192k, but we have a few tables that are experiencing chaining. We have oracle 8.1.7.3.

  2. #2
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    688
    I recommend database block size multiple or equal of ntfs block size.
    Best wishes!
    Dmitri

  3. #3
    Join Date
    Apr 2002
    Location
    Shenzhen, China
    Posts
    327
    Originally posted by kgb
    I recommend database block size multiple or equal of ntfs block size.
    I wonder if you can really have db block sie smaller than ntfs block?

    If the disk partition is dedicated to datafile files, equivalent size will be the best choice.
    Oracle Certified Master - September, 2003, the Second OCM in China
    *** LOOKING for PART TIME JOB***
    Data Warehouse & Business Intelligence Expert
    MCSE, CCNA, SCJP, SCSA from 1998

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    chaining has nothing to do with your nt block size btw

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