My Oracle Support Banner

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

Last updated on AUGUST 04, 2018

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

To view full details, 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 a vibrant support community of peers and Oracle experts.