on 03-18-2014 4:29 PM
Hi,
You can use BRTOOLS options to switch off the autoextend for PSAPSR3 table space, later you can resize and fix a maximum size for the tablespace in the BRTOOLS SPACE MGT options.
Please let me know if you still want the step by step procedure.
Thanks ,
Ahamed.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Arun,
You can make the autoextend off using
ALTER DATABASE DATAFILE '<path of datafile under PSAPSR3700>' AUTOEXTEND OFF;
Change the maxsize to 32GB keeping the autoextend on feature using
alter database datafile '<path of datafile>' autoextend on maxsize 32000M;
You may write a script to include commands for all the datafiles within the particular tablespace.
Hope this helps.
Regards,
Deepak Kori
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Arun,
For your information
Data files are not exactly unlimited in size, so the term "Unlimited" refers to the ceiling your datafile is able to reach, and it depends on the Oracle Block Size. To find the absolute maximum file size multiply block size by 4194303. This is the actual maximum size. You may want to read the Metalink Note:112011.1
.
Please check what is the blocksize (db_block_size) parameter in initSID.ora file.
If the block size is 8192 then maximum datafile size can be 32 GB.
Please execute the command to have better understanding of MaxSize in GB
select MAXBYTES/1024/1024 from dba_data_files where TABLESPACE_NAME='PSAPSR3';
Once you get the max_size of datafiles under PSAPSR3 use the below command to set maxsize for each of the datafiles to restrict the growth.
alter database datafile '<path of datafile>' autoextend on maxsize 32G;
Note: new maxsize will depend on your db_block_size parameter.
Hope this helps.
Regards,
Deepak Kori
Hello
The output is not readable.
select MAXBYTES/1024/1024 from dba_data_files where TABLESPACE_NAME='PSAPSR3';
This will give the maxsize of all the datafiles in MB.
If they are are less than 32700 MB and if you want to change the max size of the datafiles then use BRTools
brspace -c force -u / -f dfalter -a autoext -t PSAPSR3 -file all_df -i 100 -m 32700
This will set the maxsize of all the datafiles or PSAPSR3 to 32700 MB with increment of 100 MB
You can do it online
Regards
RB
It will be good to have SAP application down to avoid any issues during the changes.
Why ? Extending the MaxSize of a datafile doesn't permit the database from writing data into the datafile.
I know it can be done online. Suggestion for having application down is to avoid any locking situation that may appear due to this activity. Just a safeguarding that's all.
User | Count |
---|---|
83 | |
10 | |
10 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.