|Home • Trainings • Quiz • Tips • Tutorials • Functional • Cert Q's • Interview Q's • Jobs • Testimonials • Advertise • Contact Us|
Table Space analysis through DB02 for PSA and Change log deletion strategies
Screen will give you
details of the each process table spaced occupied
and values are in MB so you can check and do analysis for particular by
clicking double click to check which are the tables and size of the table.
If you want to check which
are the PSA tables are considering BI system then double click on that will give
you details of that PSA table wise size occupied in system.
If you want to do analysis
of PSA tables then double click on that entire PSA table and sizing will come.
Then do the descending order on Size will give you details of which PSAs have
occupied more size.
You can use RSTSODS table
to know that particular PSA table belong to which object so that based on
business scenario you can go for deletion strategies. Copy PSA name from DB02
and paste in technical ODS name in RSTSODS.
Note: Please make sure
that PSA request deletion should be only for full load specially for Master
You will find info object
or DSO or cube name in object name fields.
You can download file of
DB02 and export to excel also. Please make a practise to study system and export
PSA, cube and DSO tables and sizes for analysis and cleansing also.
Please send us your feedback/suggestions at webmaster@SAPTechnical.COM
©2006-2007 SAPTechnical.COM. All rights reserved.
product names are trademarks of their respective companies. SAPTechnical.COM
is in no way affiliated with SAP AG.
Graphic Design by Round the Bend Wizards