Updated on 2025-03-13 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 the PG_CATALOG and SYS schemas.

Table 1 V$SYSSTAT columns

Name

Type

Description

statistic#

numeric

Statistics ID.

name

character varying(64)

Statistical item name.

class

numeric

Not supported. Its value is NULL.

value

numeric

Statistical item value.

stat_id

numeric

Not supported. Its value is NULL.

con_id

numeric

Not supported. Its value is 0.