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?
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.
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.
Hi Eric & Madhu,
Thanks for your time and response.
I have 2 questions for you guys,
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?
If I want to reduce the chop size from 2 GB to 1 GB, where should I change the settings?
Please share your experience.
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
I got the confirmation from SAP that there is no necessary to have the PSAPROLL table space to be twice as big as the largest table to be reorganized but, PSAPTEMP should be twice as big as the largest index that to be reorganized.
Thanks all for your time and support.