Skip to Content

TOP 100 PSA/Changelog table list in BW on HANA

I would like to share code snippet for identifying the Top 100 Changelog/PSA table list along with size it’s consuming. This would be very helpful for house keeping activities.

SELECT

  1. M.“TABLE_NAME”,D.“DDTEXT” as TABLE_DESC,

SUM(M.“MEMORY_SIZE_IN_TOTAL”) as DBSIZE,

CAST(sum(M.“MEMORY_SIZE_IN_TOTAL” / 1073741824.0) AS DECIMAL(10, 2)) AS DBSIZE_DB

FROM M_CS_TABLES M

INNER JOIN SAPDP1.“DD02T” D

ON M.“TABLE_NAME” = D.“TABNAME”

WHERE TABLE_NAME like ‘/BIC/B%00’

GROUP BY M.“TABLE_NAME”, D.“DDTEXT”

ORDER BY  DBSIZE DESC

LIMIT 100


We can alter list by changing the LIMIT value

/wp-content/uploads/2015/12/psa_853379.jpg

Modified the SQL which would show the descriptions of the PSA or Changelog table name…I intentionally didn’t give the output of mine.


Thanks,

Shanthi Bhaskar

2 Comments
You must be Logged on to comment or reply to a post.