on 11-30-2010 10:06 AM
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
>>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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
on Windows, you can go up to 32GB if using 8K block size..
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
>>1. If I keep aotoextend on will it be a problem in future or not?
There is no issue if you keep autoextend on, until you have sufficient freespace on the disk/filesystem. Make sure that you keep the value 32GB for maxsize parameter on each datafile. Mean your datafile will not grow beyond 32 GB.
>>2. Suggest me what are the action to take as a administrator?\
If you search for Database Administration for Oracle on help.sap.com you will get a very good documentation which will help you what to do on day to day basis to maintain your database.
hi Veerab,
I also suggest you to configure CCMS auto reaction mails for the File system and table space
Cheers
George
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
10 | |
10 | |
10 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.