on 08-27-2007 1:04 PM
Hi
We are planning to performa DB reorg using SAPDBA in our production
system. During our preparatory phase we found that our largest table
GLPCA is having a size of around 6GB and our PSAPROLL table space size
is around 11.8GB...
Is that mandatory that the PSAPROLL space should be twice as big as the
largest table that to be reorganized? Also, pls confirm that whether it
is OK to carry on the DB reoorg with less PSAPROLL space than twice the
size of GLPCA table?
regards,
VInodh.
got confirmation from SAP
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
Reorg does export and you can choose R3chop to split large export dumps or via parameter "Chop: Yes". In this way, every ORACLE export dump file can be split on hard disk into any number of parts (compressed, if required) between 1M and the maximum file size.
Usually it is recommended for client copy, that a large rollback segment of PSAPROLL size be more than the size of largest table.
Regards
Madhu
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Eric & Madhu,
Thanks for your time and response.
I have 2 questions for you guys,
For Eric:
If we choose the option `Reduce Object Size = Yes` during reorg, does SAPDBA reduce the GLPCA size? In that case, the PSAPROLL area limitation will be overcome or not?
For Madhu:
If I want to reduce the chop size from 2 GB to 1 GB, where should I change the settings?
Please share your experience.
regards,
VInodh.
SAPDBA is not supported anymore, you should use BRTOOLS instead. check SAP note 646681.
from SAP help: If the menu option <b>Reduce object size: yes</b> is used, the export dump is computed more exactly or exactly (choose: estimate or compute statistics) since SAPDBA determines the storage space actually occupied by the object data and carries out the space checks using this value. The compression rate, however, is not taken into consideration here.
for reorg with SAPDBA, check http://help.sap.com/saphelp_40b/helpdata/en/0d/d2fb8c4a0c11d182b80000e829fbfe/content.htm
HTH.
this is a SAP recommendation, yes, you should follow this.
if not, reorg of GLPCA might fail near the end and you will lose valuable time.
if you want to risk losing your time for a mere 200MB, it's your call...
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Eric,
Thanks for your time and response. As you said, it is always safe to have a sufficient PSAPROLL space. By the way, did you know any OSS note which describes or recommend this scenario..I tried searching but could`nt find it.
This is to prove my customer that its SAP`s recommendation.
regards,
VInodh.
User | Count |
---|---|
84 | |
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.