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

To report this post you need to login first.

2 Comments

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

Leave a Reply