SAP Hana - System views (Data Dictionary)

About

System views are located in the SYS schema. However, as public synonyms of all views exist, it is not necessary to specify the schema name when you query these views.

Example

select * from objects where object_name like '%TABLE%' and schema_name = 'PUBLIC'

Data

Note Many system views are available in two versions:

  • one that shows the data gathered since a particular service was last started,
  • and one that shows the data gathered since the time the view was last reset.

For example, the view M_VOLUME_IO_TOTAL_STATISTICS shows the total read size and the total write size for each volume since a service was last started.

Example: The below RESET SQL statement initializes the statistics shown by this view.

ALTER SYSTEM RESET MONITORING VIEW SYS.M_VOLUME_IO_TOTAL_STATISTICS

The view M_VOLUME_IO_STATISTICS_RESET now shows the statistics since the reset time.

Documentation / Reference


Powered by ComboStrap