Hi
I have query to find out DB growth for 1 year. (option on 1 year / 6 months / 3 months) .. based on the days.
DB GROWTH
-----------
select
decode
(
grouping_id (to_char(creation_time, 'YYYY MM'))
, 1
, 'Total'
, to_char(creation_time, 'YYYY MM')
) mnth
, sum(bytes)/1024/1024/1024 growth_gb
from v$datafile
where creation_time > SYSDATE - 365
group by rollup (to_char(creation_time, 'YYYY MM'));
-- The above query will give particular DB space growth in GB. (db name like TELEPHONICA). in telephonica has several schemas.. I need to find out one schema space growth .
Please advise
BR
FRD