Updated on 2024-05-07 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 monitoring administrator 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 schema.

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.