This discussion is archived
2 Replies Latest reply: Apr 5, 2013 2:40 PM by jgarry RSS

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

MSandico Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points