统计数据库每天的数据增长量代码,MSSQL代码库,德仔网

代码语言

代码分类

【MSSQL】统计数据库每天的数据增长量

作者:hcqenjoy / 发布于2011/1/10/ 730

<div>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;</div>

评论列表

本站所提供的代码，版权归原作者所有，若有侵犯作者版权，请与我们联系，我们将立即删除或修改。谢谢!
本站所有代码发布及提供者。

试试其它关键字

　数据增长量　

同语言下

可能有用的

hcqenjoy贡献的其它代码(3)