2 Replies Latest reply: Apr 5, 2013 4:40 PM by jgarry RSS

    Optimal NTFS block size for Oracle 11G on Windows 2008 R2 (OLTP)

    MSandico
      Hi All,

      We are currently setting up an Oracle 11G instance on a Windows 2008 R2 server and were looking to see if there was an optimal NTFS block size. I've read the following: http://docs.oracle.com/cd/E11882_01/win.112/e10845/specs.htm

      But it only mentioned the block sizes that can be used (2k - 16k). And basically what i got out of it, was the different block szes affect the max # of database files possible for each database.

      Is there an optimal NTFS block size for Oracle 11G OLTP system on Windows?

      Thanks in advance