How to check total size of PSA table in BW.

[Former Member]

Dear BW Guru,

Could you please guide me how to check table present in PSA area and their size.

please also guide me to check ODS change log size and their respect table name if any.

Thank you.

Regards,

Dilip

[former_member182516]

Hi,

To get the PSA Table name go to menu of data source --> goto --> Technical Attributes --> here you can get the PSA table name.

check the below link which gives steps to find the PSA table name of the respective data source.

http://rahulursbw.wordpress.com/2010/03/21/find-the-psa-database-table-and-data/

2) Change log table naming conventions will be "/BIC/A,DSO NAME>00

next goto DB02 --> Space folder --> "single Table Analysis" --> enter the PSA table/Change log table in the name area and click enter it will display the size of the tables.

Hope this helps...

Regards

KP

[Former Member]

DB02 -> Additional Functions -> BW Analysis

Counts and sizes of different types of BW tables are listed, including PSA and ODS & Changelog.

Double click on a row to list all the individual items.

[Former Member]

DB02 -> Table Spaces / Segments -> Detail Analysis (your table)

[naresh_babu3]

Hi

U can check the Top 30 PSA and ODS size in ST14.

Naresh

[former_member210253]

Hi Ram,

U can check in RSCUSTV6 also.

Regards,

Babu

[Former Member]

Hi,

You can check the size of the tablespace in DB02,

The PSA tablespace is typically named PSAPODS*.

If you are looking at individual PSA table, check its technical attributes in SE11 to get the tablespace.

Regards,

Aravind.

[Former Member]

Hi Dilip,

You can find PSA table names by looking into SE11 give table name RSTSODS, execute the table giving the technical name of PSA.

To find the size of PSA  execute the function module DB_GET_TABLE_SIZE and give the input: technical name of PSA ( Like   /BIC/B0000214000 ) and execute.. you can know the size of PSA.

Please assign points you found the solution.

regards,

Pankaj.

[JasonLax]

This thread was in SCN Support, which is the support space for SAP Community Network and not SAP products.  I've moved it to

Please select an appropriate space where topic experts will see and reply to it: SCN Site Index