My Oracle Support Banner

Select on V$IOSTAT_FILE from a PDB returns no rows (Doc ID 1592877.1)

Last updated on JANUARY 07, 2025

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.1 to 12.1.0.1 [Release 12.1]
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

 Select on V$IOSTAT_FILE from a PDB returns no rows.   Same select from the CDB does return rows.

SQL> show con_id
 
CON_ID
------------------------------
1
SQL> select file_no from v$iostat_file where con_id=3;
 
   FILE_NO
----------
         3
        11
        12
        13
        14
 
SQL> alter session set container = orcl_pdb1;
 
Session altered.
 
SQL> show con_id
 
CON_ID
------------------------------
3
SQL> select file_no from v$iostat_file where con_id=3;
 
no rows selected

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Changes
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.