Updated on 2025-05-29 GMT+08:00

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.

Table 1 GLOBAL_REL_IOSTAT columns

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.