您的位置:寻梦网首页编程乐园Java天地JSP 专辑JSP001 HTML 离线版
Java 天地
JSP001 HTML 离线版
FAQ汇萃 >> Oracle 专栏 >> 显示去年里数据库的每个月的空间增长情况

由 macro 发布于: 2001-03-03 09:25

set pagesize 50000
tti "Database growth per month for last year"

select to_char(creation_time, 'RRRR Month') "Month",
sum(bytes)/1024/1024 "Growth in Meg"
from sys.v_$datafile
where creation_time > SYSDATE-365
group by to_char(creation_time, 'RRRR Month')
/

tti off



Month Growth in Meg
--------- -------------
2000 12月 304.382813
2001 1月 105




资料来源: JSP001.com