select to_char(FIRST_TIME, 'yyyy/mm/dd hh24'), count(*) from v$log_history group by to_char(FIRST_TIME, 'yyyy/mm/dd hh24') order by 1;