One of the simple way to find the growth of the database is using v$datafile view. following is the simple query and its output which gives the growth trend in month and year
</code> SQL>select to_char(CREATION_TIME,'RRRR') year, to_char(CREATION_TIME,'MM') month, round(sum(bytes)/1024/1024/1024) GB 2 from v$datafile 3 group by to_char(CREATION_TIME,'RRRR'), to_char(CREATION_TIME,'MM') 4 order by 1, 2; YEAR MO GB ---- -- ---------- 2004 10 14 2004 11 66 2004 12 47 2005 01 15 2005 02 14 2005 03 34 2005 04 14 2005 05 30 2005 06 5 2005 07 3 2005 08 9 YEAR MO GB ---- -- ---------- 2005 10 4 2005 12 20 2006 01 11 2006 02 15 2006 03 14 2006 04 16 2006 05 13 2006 06 0 2006 07 4 2006 08 17 2006 09 5 YEAR MO GB ---- -- ---------- 2006 10 6 2006 11 0 2006 12 30 2007 01 4 2007 02 4 2007 03 6 2007 04 6 2007 05 12 2007 06 15 2007 07 62 2007 08 29 YEAR MO GB ---- -- ---------- 2007 09 18 2007 11 20 2007 12 8 2008 03 8 2008 05 4 2008 08 11 2008 09 14 2008 10 4 2008 11 36 2008 12 49 2009 01 8 YEAR MO GB ---- -- ---------- 2009 02 38 2009 03 35 2009 04 54 2009 05 73 2009 08 1 2009 09 12 2009 10 78 2009 11 105 2009 12 113 2010 01 109 2010 02 79 YEAR MO GB ---- -- ---------- 2010 03 84 2010 05 243 2010 06 225 2010 07 244 2010 08 152 2010 09 40 2010 10 176 2010 11 76 2010 12 107 64 rows selected. <code>
Persistent Storage Solutions 