Updated on 2025-05-29 GMT+08:00

V$SYSSTAT

V$SYSSTAT displays the resource usage of the entire database instance since the database instance is started. By default, only the initial user or MONADMIN can access the database. Other users can access the database only after being granted the MONADMIN permission. This view exists in both PG_CATALOG and SYS schemas. In the multi-tenancy scenario, for metrics supported by a PDB, global statistics are returned if this view is accessed in a non-PDB, and statistics about a PDB is returned if this view is accessed in the PDB. For metrics not supported by a PDB, global statistics are returned if this view is accessed in a non-PDB, and no information is returned if this view is accessed in a PDB. For metrics that are not adapted to multi-tenancy scenario, the original information is returned.

Table 1 V$SYSSTAT columns

Name

Type

Description

statistic#

numeric

Statistics ID.

name

character varying(64)

Statistical item name.

class

numeric

Not supported. The value is NULL.

value

numeric

Statistical item value.

stat_id

numeric

Not supported. The value is NULL.

con_id

numeric

Not supported. The value is 0.