Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

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

MSandicoApr 5 2013 — edited Apr 5 2013

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

Locked Post

New comments cannot be posted to this locked post.

Locked on May 3 2013

Added on Apr 5 2013

#general-database-discussions

2 comments

4,179 views