SAP Virtual/Onsite Trainings

Document Categories:

What's New?

Contribute?

Sample Specs

What's Hot?

Web Dynpro for ABAP Tutorials 


Join the Mailing List
Enter name and email address below:
Name:
Email:
Subscribe  Unsubscribe 

Table Space analysis through DB02 for PSA and Change log deletion strategies

...Previous

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 data.

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 

HomeContribute About Us Privacy Terms Of Use • Disclaimer • SafeCompanies: Advertise on SAPTechnical.COM | Post JobContact Us  

Graphic Design by Round the Bend Wizards

footer image footer image