Wednesday, 23 November 2016

Script to find out database growth !!!

set pages 2000
set linesize 2000
select to_char(CREATION_TIME,'RRRR') year, to_char(CREATION_TIME,'MM') month, round(sum(bytes)/1024/1024/1024) GB from   v$datafile
group by  to_char(CREATION_TIME,'RRRR'),   to_char(CREATION_TIME,'MM')

order by   1, 2;



No comments:

Post a Comment