Skip to Content
0
Jan 24, 2023 at 09:05 AM

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

112 Views

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/5e783b7f5a9749bcbfffe167524aeccc.html) 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?