Please suggest on Autoextend on and file size

[Former Member]

Hi Experts,

We have installed SAP ecc 6.0 system on oracle 10.2.0. Our file system & tablespace setting is AUTO Extend on.

1. Some files in the database reached the size above 30GB. will it be problem if the size of datafiles is grown above 30GB?

2. If we have sufficient space at file system, is it suggestable to keep file settings auto extend on for oracle database?

Kindly advice me.

Thanks in advance

Regards

Veera

[Former Member · Accepted solution]

>>1. Some files in the database reached the size above 30GB. will it be problem if the size of datafiles is grown above 30GB?

Yes, if the max file size is 30GB then the datafile will not grow beyond 30GB. You need to add another datafile.

>>2. If we have sufficient space at file system, is it suggestible to keep file settings auto extend on for oracle database?

yes, if you have sufficient free space on filesystem then you can use the autoextend datafiles.

[Former Member · Accepted solution]

Hi Sunil,

what is the maximum datafile size in oracle 10g for SAP ecc 6.0 ( for a non bigfile tablespace)

Regards

veera

[former_member524429 · Accepted solution]

Hi,

OS ?

Maximum File size varies from OS to OS. Refer [SAP Note 129439 - Maximum file sizes with Oracle|https://service.sap.com/sap/support/notes/129439] to get more detailed information. With HP_UX 64GB of File size with db block size of 16KB is possible theoretically.

I would suggest you to Maintain main Table spaces manually (PSAPSR3, PSAPSR3DB, PSAPSR3USER,PSAPSR3700) with small data file sizes (10 to 20 GB in size), based on its Daily/Weekly/Monthly growth rate calculation.

Regards,

Bhavik G. Shroff