SQL語言:?統計數據庫每天的數據增長量 set?linesize?1000? set?pagesize?100? select?t.* ??from?(SELECT?D.TABLESPACE_NAME, ???????????????SPACE?"SUM_SPACE(M)", ???????????????BLOCKS?SUM_BLOCKS, ???????????????SPACE?-?NVL(FREE_SPACE,?0)?"USED_SPACE(M)", ???????????????ROUND((1?-?NVL(FREE_SPACE,?0)?/?SPACE)?*?100,?2)?"USED_RATE(%)", ???????????????FREE_SPACE?"FREE_SPACE(M)" ??????????FROM?(SELECT?TABLESPACE_NAME, ???????????????????????ROUND(SUM(BYTES)?/?(1024?*?1024),?2)?SPACE, ???????????????????????SUM(BLOCKS)?BLOCKS ??????????????????FROM?DBA_DATA_FILES ?????????????????GROUP?BY?TABLESPACE_NAME)?D, ???????????????(SELECT?TABLESPACE_NAME, ???????????????????????ROUND(SUM(BYTES)?/?(1024?*?1024),?2)?FREE_SPACE ??????????????????FROM?DBA_FREE_SPACE ?????????????????GROUP?BY?TABLESPACE_NAME)?F ?????????WHERE?D.TABLESPACE_NAME?=?F.TABLESPACE_NAME(+) ????????UNION?ALL ????????SELECT?D.TABLESPACE_NAME, ???????????????SPACE?"SUM_SPACE(M)", ???????????????BLOCKS?SUM_BLOCKS, ???????????????USED_SPACE?"USED_SPACE(M)", ???????????????ROUND(NVL(USED_SPACE,?0)?/?SPACE?*?100,?2)?"USED_RATE(%)", ???????????????SPACE?-?USED_SPACE?"FREE_SPACE(M)" ??????????FROM?(SELECT?TABLESPACE_NAME, ???????????????????????ROUND(SUM(BYTES)?/?(1024?*?1024),?2)?SPACE, ???????????????????????SUM(BLOCKS)?BLOCKS ??????????????????FROM?DBA_TEMP_FILES ?????????????????GROUP?BY?TABLESPACE_NAME)?D, ???????????????(SELECT?TABLESPACE, ???????????????????????ROUND(SUM(BLOCKS?*?8192)?/?(1024?*?1024),?2)?USED_SPACE ??????????????????FROM?V$SORT_USAGE ?????????????????GROUP?BY?TABLESPACE)?F ?????????WHERE?D.TABLESPACE_NAME?=?F.TABLESPACE(+))?t order?by?"USED_RATE(%)"?desc;
? 版權聲明
文章版權歸作者所有,未經允許請勿轉載。
THE END