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