Find the archivelog size hour by hour

Find the archivelog size hour by hour







select trunc(COMPLETION_TIME,’HH24′) TIME, SUM(BLOCKS * BLOCK_SIZE)/1024/1024 SIZE_MB from V$ARCHIVED_LOG group by trunc (COMPLETION_TIME,’HH24′) order by 1;

  • September 7, 2015 | 12 views
  • Comments