Skip to Content
avatar image
Former Member

Please suggest on Autoextend on and file size

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Best Answer
    avatar image
    Former Member
    Nov 30, 2010 at 10:09 AM

    >>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.

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • Nov 30, 2010 at 08:00 PM

    on Windows, you can go up to 32GB if using 8K block size..

    Add comment
    10|10000 characters needed characters exceeded

    • hi,

      check the maximum size for your datafiles, they must not exceed 32GB. If they were set to unlimited, you will have Oracle errors when it tried to grow above 32GB.

      BRSPACE will help you set this up.

  • avatar image
    Former Member
    Nov 30, 2010 at 10:33 AM

    hi Veerab,

    I also suggest you to configure CCMS auto reaction mails for the File system and table space

    Cheers

    George

    Add comment
    10|10000 characters needed characters exceeded