HANA sql statement - schema size

[rkamalov]

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

[pfefferf]

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.

[Former Member]

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 ?