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.
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. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot