Simple way of finding list of PSA tables and Size in BW system
Most of the times, we would like to know complete information about PSA tables to perform system cleaning and to keep space available for system performance as part or System Maintenance.
1) First we need to find list of PSA tables available in BW system. To achieve this we need to go to DB02 Tcode first and select “Tables and Indexes” as shown given below.
2) Provide input as shown given below and hit enter.
3) You will get the information as shown given below.
4) Now perform sorting on size in descending order. Here we will get to know the PSA tables according to their size.
5) Now based on the table name, we can find the data source information.
Please go to SE11, provide PSA table name for which you want to find the Data Source Name as shown given below.
With this information, we can find the PSA table sizes and their data source names to take action further to keep system clean.
Hope this will help you.
Regards,
Ravi K Chandragiri
Simple but very useful. Thanks for this.
I have a question. I am sorry if it's silly. But, I am not able to find "Tables and Indexes" in my system at DB02. So, is it some kind of setting that we need to request Basis?
Thanks,
Vikranth.
Check with BASIS Team, they can help you on this.
use largest tables and filter on */BIC/B*
Hi ravi chandragiri ,
Smart way of finding PSA tables and sizes
Thanks for sharing.
Regards,
Suman
Good snippet to do this job.
Thanks for sharing,
Hari Charan BR
Thanks Ravi for showing very simple way.....
Hi,
Nice document.
Thanks,
Phani.
Superb blog Ravi. Really very useful. Thanks for shariing...:)
Regards,
Poorna
Thank you all for liking this blog.
Hello Ravi,
Its a very useful blog in terms of optimization or value addition .Appreciate for sharing the same.
Regards
YN
Thank you Yogesh.
Nice man....