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.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot