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

Last updated on OCTOBER 22, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.1 to 12.1.0.1 [Release 12.1]
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
 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms