archive log genereation trend
please let me know or confirm if with this query I could get a archive log generation trend
SQL> r
1 SELECT TO_CHAR(FIRST_TIME,'DD-MON-YYYY HH24'),
2 COUNT(*)
3 FROM V$LOGHIST
4 WHERE TO_CHAR(FIRST_TIME,'DD-MON-YY HH24') > '01-FEB-2010'
5 GROUP BY TO_CHAR(FIRST_TIME,'DD-MON-YYYY HH24')
6* ORDER BY TO_CHAR(FIRST_TIME,'DD-MON-YYYY HH24') ASC
TO_CHAR(FIRST_TIME,' COUNT(*)
-------------------- ----------
06-MAR-2010 03 15
06-MAR-2010 04 19
06-MAR-2010 05 20
06-MAR-2010 06 20
06-MAR-2010 07 21
06-MAR-2010 08 15
06-MAR-2010 09 5
06-MAR-2010 10 4
the thing here with this query it's that i can not get the generation history of the last months, could you let me know why or help me to get another way of get this report