GLOBAL_REL_IOSTAT
Displays statistics about data file I/Os on all nodes, as shown in Table 1. In the multi-tenancy scenario, global information is returned if this view is accessed in a non-PDB, and information about a PDB is returned if this view is accessed in the PDB. The I/O statistics queried through this view in the PDB are persistent. After the database is restarted, the I/O statistics are not cleared and are accumulated continuously.
Name |
Type |
Description |
---|---|---|
node_name |
name |
Node name. |
phyrds |
bigint |
Number of times of reading physical files. |
phywrts |
bigint |
Number of times of writing into physical files. |
phyblkrd |
bigint |
Number of times of reading physical file blocks. |
phyblkwrt |
bigint |
Number of times of writing into physical file blocks. |
dbid |
oid |
If the multi-tenancy feature is not enabled, the value is always 0. If the multi-tenancy feature is enabled, the value is the database ID corresponding to a PDB during query in the PDB and is always 0 during query in a CDB. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.