oracle 查看 pdb名称,oralce 12c 表空间查询(包含pdb)

SELECT DB_NAME

,con_id

,RES_NAME

,TABLE_SIZE

,USED_SIZE

,USE_PERCENT

,AVA_SIZE

,AUTOEXTENSIBLE

,CONTENTS

FROM (

SELECT tt.con_id

,nvl(x.name, 'CDB$ROOT') AS DB_NAME

,ts1.tablespace_name AS "RES_NAME"

,round(nvl(tt.tmp_max_size, 0) / 1024 / 1024, 2) AS "TABLE_SIZE"

,round(nvl(tu.tmp_used_size, 0) / 1024 / 1024, 2) AS "USED_SIZE"

,CASE

WHEN tt.tmp_space = 0

THEN 0

ELSE ROUND((nvl(tu.tmp_used_size, 0) * 100 / tt.tmp_max_size), 2)

END AS "USE_PERCENT"

,round((nvl(tt.tmp_max_size, 0) - nvl(tu.tmp_used_size, 0)) / 1024 / 1024, 2) AS "AVA_SIZE"

,ts1.CONTENTS AS "CONTENTS"

,ts1.STATUS AS "STATUS"

,ts1.ALLOCATION_TYPE AS "ALLOCATION_TYPE"

,tt.tmp_file_count AS "FILE_COU