Overview
OceanBase Database collects a series of runtime SYSSTAT metrics to provide fine-grained insights into the system's operating status. These metrics are one of the core bases for determining the health status of the database and are designed to meet the needs of diverse O&M scenarios, including daily monitoring, fault diagnosis, and performance optimization.
Core views
The SYSSTAT metric information of OceanBase Database is stored in a series of dynamic performance views. The main views are as follows:
V$STATNAME view
Provides the definitions of all monitorable statistical events (such as name, ID, and category).
V$SESSTAT view
Stores monitoring item information at the session level. These values are valid only for the current connected session and are temporary. When a session is disconnected, the corresponding records of that session in the
V$SESSTATview are cleared.V$SYSSTAT view
Stores the cumulative values of all monitoring items since the OBServer instance is started. This data is system-level global information and is not cleared due to the disconnection of individual sessions. It is reset only after the database instance is shut down.
In short, V$STATNAME is the basis for querying and understanding the specific statistical values in views such as V$SYSSTAT and V$SESSTAT. The V$SESSTAT view reflects the activity volume of a single session, and its lifecycle is consistent with that of the session. The V$SYSSTAT view reflects the total activity volume of the OBServer instance since startup, and its lifecycle is consistent with that of the instance.