查看Oracle12c容器数据库数据文件分布情况

查询Oracle12c/Oracle19c数据文件分布明细

set linesize 300 pagesize 300
col tablespace_name for a17
col data_file for a90 
col pdb_name for a15

SELECT 
    (SELECT c.name
    FROM v$tablespace c
    WHERE c.ts#=a.ts#
    		AND c.con_id=a.con_id) tablespace_name,a.file#,a.con_id,b.name pdb_name,b.guid,a.name data_file
FROM v$datafile a
LEFT JOIN v$containers b
	ON (a.con_id=b.con_id);