How to find HANA disk size of COLLECTION (Document stores) in HANA

[former_member826060]

We need to calculate the disk size of our Hana DB which includes all table types (ROW, COLUMN and COLLECTION). We used below query to achieve this.

select sum((disk_size)/1024/1024/1024) from m_table_persistence_statistics;

But this is not giving disk_size for collection

As per the document (https://help.sap.com/docs/SAP_HANA_PLATFORM/6b94445c94ae495c83a19646e7c3fd56/5e783b7f5a9749bcbfffe16...) Collections use like tables and users can work with them in SQL in a similar fashion like tables.

1. May I know why M_TABLE_PERSISTENCE_STATISTICS in not having the information for COLLECTION (Document stores)?

2. Is there any way to get disk storage information for Document stores?

3. when we LOAD [collection] , what is the active time period for which a COLLECTION is loaded in memory?

[Cocquerel]

When data is loaded into memory, you can get some size information in the system view SYS.M_COLLECTION_TABLES