SAP HANA -System and Statistics Views in Multiple-Container Systems

Every multitenant database container system has its own SYS and _SYS_STATISTICS schemas that contain information about that database only. For system-level monitoring, additional views are accessible in the system database: the M_DATABASES (SYS) view and the views in the SYS_DATABASES schema.

  • M_DATABASES

    This view is available in the SYS schema of the system database of a multiple-container system. It provides an overview of all tenant databases in the system. Only users with the system privilege DATABASE ADMIN can see the contents of this view.

  • SYS_DATABASES schema

    The views in the SYS_DATABASES schema provide aggregated information from a subset of the views available in the SYS and _SYS_STATISTICS schemas of all tenant databases in the system. These union views have the additional column DATABASE_NAME to make it possible to identify from which database the information is coming refers. The system views in the SYS_DATABASES schema are accessible only from the system database. To be able to view information in these views, you need the system privilege DATABASE ADMIN or CATALOG READ.

Tools such as the SAP HANA cockpit use these views to support system-level monitoring of multiple-container systems.

Figure 1: System and Statistics Views in Multiple-Container Systems

Leave a Reply