您好,登錄后才能下訂單哦!
SELECT nvl(t.name, 'CDB$ROOT') as DB_NAME,
D.TABLESPACE_NAME,
TOTAL_SPACE,
(SPACE - NVL(FREE_SPACE, 0)),
ROUND((SPACE - NVL(FREE_SPACE, 0)) / TOTAL_SPACE * 100, 2) ratio,
FREE_SPACE
FROM (SELECT TABLESPACE_NAME,
con_id,
ROUND(SUM(BYTES) / (1024 * 1024), 2) SPACE,
ROUND(SUM(decode(maxbytes, 0, bytes, maxbytes)) /
(1024 * 1024),
2) TOTAL_SPACE,
SUM(BLOCKS) BLOCKS
FROM containers(DBA_DATA_FILES)
GROUP BY TABLESPACE_NAME, con_id) D,
(SELECT TABLESPACE_NAME,
con_id,
ROUND(SUM(BYTES) / (1024 * 1024), 2) FREE_SPACE
FROM containers(DBA_FREE_SPACE)
GROUP BY TABLESPACE_NAME, con_id) F,
v$pdbs t
WHERE D.TABLESPACE_NAME = F.TABLESPACE_NAME(+)
and D.CON_ID = F.CON_ID
and F.con_id = t.CON_ID(+)
UNION ALL
SELECT nvl(t.name, 'CDB$ROOT') as DB_NAME,
D.TABLESPACE_NAME,
SPACE,
USED_SPACE,
ROUND(NVL(USED_SPACE, 0) / SPACE * 100, 2) ratio,
NVL(FREE_SPACE, 0)
FROM (SELECT TABLESPACE_NAME,
con_id,
ROUND(SUM(decode(maxbytes, 0, bytes, maxbytes)) /
(1024 * 1024),
2) SPACE,
SUM(BLOCKS) BLOCKS
FROM containers(DBA_TEMP_FILES)
GROUP BY TABLESPACE_NAME, con_id) D,
(SELECT TABLESPACE_NAME,
con_id,
ROUND(SUM(BYTES_USED) / (1024 * 1024), 2) USED_SPACE,
ROUND(SUM(BYTES_FREE) / (1024 * 1024), 2) FREE_SPACE
FROM containers(V$TEMP_SPACE_HEADER)
GROUP BY TABLESPACE_NAME, con_id) F,
v$pdbs t
WHERE D.TABLESPACE_NAME = F.TABLESPACE_NAME(+)
and D.CON_ID = F.CON_ID
and F.con_id = t.CON_ID(+)
ORDER BY 1
免責(zé)聲明:本站發(fā)布的內(nèi)容(圖片、視頻和文字)以原創(chuàng)、轉(zhuǎn)載和分享為主,文章觀點(diǎn)不代表本網(wǎng)站立場(chǎng),如果涉及侵權(quán)請(qǐng)聯(lián)系站長(zhǎng)郵箱:is@yisu.com進(jìn)行舉報(bào),并提供相關(guān)證據(jù),一經(jīng)查實(shí),將立刻刪除涉嫌侵權(quán)內(nèi)容。