Updated on 2024-06-03 GMT+08:00

V$SYSSTAT

V$SYSSTAT displays the resource usage of the entire database instance since the database instance starts to run. 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 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. Set it to NULL.

value

numeric

Statistical item value.

stat_id

numeric

Not supported. Set it to NULL.

con_id

numeric

Not supported. Set it to 0.