Skip to Content
avatar image
Former Member

Suggested data file size for Oracle 11

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!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Sep 19, 2011 at 12:37 PM

    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

    Add comment
    10|10000 characters needed characters exceeded