Skip to Content

HANA sql statement - schema size

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

Add comment
10|10000 characters needed 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.

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    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 ?

    Add comment
    10|10000 characters needed characters exceeded