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?