Suggested data file size for Oracle 11

[Former Member]

Hi all,

Creating a new system (SolMan 7.1) on AIX 6.1 running Oracle 11.

I have 4 logical volumes for data sized at 100gb each. During the installation I'm being asked to input the size for the data files. The default is "2000mb/2gb" is this acceptable for a system sized like mine, or should I double them to 4gb each? I know the max is 32gb per data file but that seems a bit large to me. Just wanted to know if there was a standard best practice for this, or a formula to use based on system sizing.

I was not able to find any quick suggestions in the Best Practices guide on this unfortunately...

Any help would be greatly appreciated.

Thanks!

[Former Member · Accepted solution]

Hi all,
> 
> Creating a new system (SolMan 7.1) on AIX 6.1 running Oracle 11.  
> 
> I have 4 logical volumes for data sized at 100gb each.  During the installation I'm being asked to input the size for the data files. The default is "2000mb/2gb" is this acceptable for a system sized like mine, or should I double them to 4gb each? I know the max is 32gb per data file but that seems a bit large to me.  Just wanted to know if there was a standard best practice for this, or a formula to use based on system sizing.
> 
> I was not able to find any quick suggestions in the Best Practices guide on this unfortunately...
> 
> Any help would be greatly appreciated.
> 
> Thanks!

Hi Ben,

Check the note 129439 - Maximum file sizes with Oracle

Best regards,

Orkun Gedik

[Former Member · Accepted solution]

Thanks Orkun!

This note solved my issue.