oraclesql表空间利用率

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

网站名称：oraclesql表空间利用率
文章起源：https://www.cdcxhl.com/article46/jpochg.html

成都网站建设公司_创新互联，为您提供域名注册、移动网站建设、商城网站、网页设计公司、网站收录、微信小程序

广告

声明：本网站发布的内容（图片、视频和文字）以用户投稿、用户转载内容为主，如果涉及侵权请尽快告知，我们将会在第一时间删除。文章观点不代表本网站立场，如需处理请联系客服。电话：028-86922220；邮箱：631063699@qq.com。内容未经允许不得转载，或转载时需注明来源： 创新互联