alter session set nls_date_format=’dd-mon-yy hh24:mi’;
SELECT A.*, Round(A.Count#*B.AVG#/1024/1024) HOURLY_Avg_Mb
FROM (SELECT To_Char(First_Time,’YYYY-MM-DD HH24′) HOUR, Count(1) Count#,
Min(RECID) Min#, Max(RECID) Max#
FROM v$log_history
GROUP BY To_Char(First_Time,’YYYY-MM-DD HH24′)
ORDER BY 1 DESC) A,
(SELECT
Avg(BYTES) AVG#, Count(1) Count#, Max(BYTES) Max_Bytes, Min(BYTES) Min_Bytes
FROM v$log) B;