Skip to Content
author's profile photo Former Member
Former Member

memory utilization for each tables in a schema


Hi,

Is there a way we can find the memory utilization for each tables for a particular schema in HANA.

Thank you

Jonu

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Posted on Feb 11, 2014 at 06:08 PM

    Hi Jonu,

    You can get info of all column tables and their memory utilization from M_CS_TABLES View

    You can get info of all row tables and their memory utilization from M_RS_TABLES View

    To find all tables for a particular schema, just filter that schema

    SELECT * FROM "SYS"."M_CS_TABLES" WHERE SCHEMA_NAME = '<YOURSCHEMANAME>'

    These Monitoring views are present in SYS schema

    Regards,

    Vivek

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Feb 11, 2014 at 07:05 PM

    Adding to Vivek's reply,

    for other system information related tables, have a look on the below blog:

    SAP HANA Administration tables/views

    TOTAL_SIZE_IN_MEMORY ( Main + Delta ) from M_CS_TABLES will give you the exact information you are looking out for.

    Regards,

    Krishna Tangudu

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Jonu,

      Adding to Vivek's reply,

      Is your question on how much memory is consumed in Main & Delta Memory? if you see the table details properly:

      MEMORY_SIZE_IN_TOTAL Total memory size is the sum of memory size in main, delta, and history parts

      MEMORY_SIZE_IN_MAIN Current memory consumption in main; this value varies depending on the number of attributes actually loaded

      MEMORY_SIZE_IN_DELTA Current memory consumption in delta

      If you want to check the size on the disk,

      SELECT DISK_SIZE FROM M_TABLE_PERSISTENCE_STATISTICS WHERE SCHEMA_NAME = <yourschema> and TABLE_NAME = <yourtablename>

      Regards,

      Krishna Tangudu

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.