Issue with SQL

[Former Member]

Hi All,

We have the standard sap sql for the table size

HANA_Tables_TopGrowingTables_Size_History

when I try to see the data through the view which the sql is using I cant see the data for the SAP Schema at all.

Currently the view which is being used is _SYS_STATISTICS.GLOBAL_TABLE_PERSISTENCE_STATISTICS

Not sure what is the problem here.

Has anyone tried pulling up the history for the top growing tables.

is there any way to pull up the size history for the tables in SAP schema.

Thanks

[Former Member · Accepted solution]

Don't see the data corresponding to SAP tables in this table.

GLOBAL_TABLE_PERSISTENCE_STATISTICS_BASE

Where does the statistics server collect data like size history for the tables residing in the SAP schema.

[Former Member · Accepted solution]

why cant you use DBACOCKPIT to identify the top growing tables . I have used the same to identify the top growing tables.

[Former Member · Accepted solution]

Hi Pavan,

Can you please check my query again.