Skip to Content

HANA sql statement - schema size

Jul 21, 2017 at 05:11 AM


avatar image

Hi, everyone!

Is there a sql-statement to determine the REAL size of a schema in HANA?

sql request provided by SAP is not showing schema size, it shows schema RAM consumption.

select SCHEMA_NAME as "Schema", round(sum(MEMORY_SIZE_IN_TOTAL) /1024/1024) as "MB Used" from M_CS_TABLES GROUP by SCHEMA_NAME order by "MB Used" desc

I'm able to determine true schema size by exporting schema and measuring exported folder.
According to request results SBOCOMMON consumes 9 MB memory, but the real size of schema - 3,7 GB

currently I'm using script that exports and measures exported schema size automatically

10 |10000 characters needed characters left characters exceeded

Please can you add an explanation, what "REAL" size of a schema means for you. According you your description I would expect that you mean the uncompressed size of the data stored in a specific schema.

* Please Login or Register to Answer, Follow or Comment.

1 Answer

Houssem Eddine Hariz Jul 21, 2017 at 08:57 AM

Hi Rinat,

I looked for a similar function or sql statement a year ago and I didn't find it, so I create a procedure that gives a real size of column, table or schema. I can post the code if you want.

Can you tell me which script did you use to export and mesure schema ?

10 |10000 characters needed characters left characters exceeded