select SUM(to_char(to_date(time,' hh24'),'hh24') d1),
count(*) from
v$log_history
group by to_char(to_date(time,'mm/dd/rr hh24:mi:ss'),'dd-mon-yyyy')
/