Skip to Content
avatar image
Former Member

Display all the columns loaded in RAM

Hi,

in a SAP system based on HANA, I'm able to find which tables (column store) are loaded on HANA and if are loaded "FULL", "NONE" or "PARTIALLY".

But if a table is partially loaded, how could I identify which columns are loaded and which none? Is there a way to see this information for all tables?

Thanks

Regards,

Mark

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Aug 19, 2015 at 01:28 AM

    Hi Mark,

    Try the script I attached.

    Best regards,

    Candy Zhan

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Mark,

      I test '-1 RESULT_ROWS', it really does not work as expected strangely. But I will check it later.

      Maybe you can try to increase the RESULT_ROWS, 10000 or more.  Or specify the table you want to see.

      Best regards,

      Candy

  • avatar image
    Former Member
    Aug 21, 2015 at 06:11 AM

    Hi Mark,

    you will be able to see the details from "Runtime information tab"

    Double click on the table -> runtime information -> coloumns -> under columns "loaded" tab

    here you can find the details .

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Colleagues,

      Just complementing, there's some internal fields $$ that if not loaded the table will stay in PARTIALLY.

      It's not a problem stay PARTIALLY, if the queries don't need such columns don't need to stay in memory.

      You can see all columns and these internal fields quering M_CS_ALL_COLUMNS view.

      Regards, Fernando Da Rós