LOCAL_REL_IOSTAT
Displays the accumulated I/O status of all data files on the current node, 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 |
|---|---|---|
| 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. |
