Database Growth pattern
Hi All
The following script gives me the database growth as follows
select to_char(creation_time, 'RRRR Month') "MONTH",
sum(bytes)/1024/1024/1024 "GROWTH IN GIG"
from sys.v_$datafile
where creation_time > SYSDATE-365
group by to_char(creation_time, 'RRRR Month');
MONTH GROWTH IN GB
2004 JAN 8
2004 AUG 6
2004 OCT 5
How can I manipute the above query to give the growth patern as follows
2004 JAN
2004 FEB
2004 MAR
--
--
--
2004 NOV
Any help will be highly appreciated.
Thanks
Arsene Lupain
The lie takes the elevator, the truth takes the staircase but ends up catching up with the lie.