Datafile size and auto extend option

[Former Member]

Hello all,

We are deploying many sap applications in our company (ECC,BW, PO, FI,...) and i have some doubts about the database configuration.

Firstly is there any best practice regarding the size of the data files (we are using 10G). Secondly, how about using the auto extend enabled in our data files? Is it a good practice? And the last one is about the size of the next extend. I saw that the installation have create with 20mb of size. How could we estimate the size of the next extend? 

It's my first time here. So, if my question was posted in the wrong place, please let me now.

Regarding,

Melo - BR,

[Reagan · Accepted solution]

Hello

I believe you will be using BR*Tools to manage the Oracle databases.

I suggest you to read these SAP notes to have an outlook on this.

129439 - Maximum file sizes with Oracle

592393 - FAQ: Oracle

I prefer to keep the data files with an initial size of 3072 MB and in auto extend mode with the max size set to 32 GB with increment of 512 MB or 1024 MB.

Regards

RB

[Former Member · Accepted solution]

Yes, we are using BR*Tools.

Does the increment size affects performance?

Regards,
Melo

[Reagan · Accepted solution]

As far as I know it shouldn't be a problem and I have never experienced an performance related issues. I have even extended tablespaces with an increment of 250 MB just because the existing datafiles were created in the same way.

[Former Member · Accepted solution]

Reagan, thank you for your replies!

Rafael Melo