on 05-06-2009 7:15 PM
Hello SAP Friends,
We have an issue with the SAPSR3DB.VIRSA_CC_ACTVL table. It is becoming full quite frequently. Do any one of you have any idea about the issue while running background job for analysis.
Error while executing the Job:ORA-01653: unable to extend table SAPSR3DB.VIRSA_CC_ACTVL by 8192 in tablespace PSAPSR3DB
Increasing tablespace is an option but can you suggest if there is any workaround for the situation. We want to avoid increasing the tablespace.
I appreciate your help..
Regards,
Venkateswara Rao
Hello,
Refer to Alprsh's recommendations. Also, SAP Note : 1044174 may help you
Harleen
SAP GRC RIG
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I have read the SAP notes suggested by Alpesh and Harleen. I spoke to the Database admin regarding the following tables for re-organization:
Tables: VIRSA_CC_ACTVL
VIRSA_CC_BKGINP
VIRSA_CC_JOBHST
VIRSA_CC_PRMVL
VIRSA_CC_SCHEDULER
VIRSA_CC_THREAD
He said that it will save around 4Gb only.
Can you tell me if by setting the following thing in CC>Config>"Additional Options"
Enable Offline Risk Analysis -
Will we be able to save up space? Our main concern is not to increase further the size because of cost issues. We already increased the size twice earlier. The system was designed as per the sizing guidelines earlier. Thhanks both.
Thanks for your reply Sudip as well...We will configure automatic addition of tablespace soon after we resolve this issue....
Regards,
Venkateswara Rao
Rao,
You can do autoextend on Oracle so you don't have to do this manually or follow the sizing guide so you can size your servers properly and you won't have to face this issue. Here is the link to the sizing guide:
Look at OSS note # 1178370 as well.
Regards,
Alpesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
You can follow one of the following approches to avoid the current problem,
1) Make the datafile in autoextend on.
Example,
alter database datafile '/u01/app/oracle/ts_32k.dbf' autoextend on;
OR
2) Resize the datafile
alter database datafile '/u01/app/oracle/ts_32k.dbf' resize 50M;
Regards,
Sudip...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.