Archive generated on day to Day basis :
select trunc(first_time, 'DD') , count(*) from v$loghist
group by trunc(first_time, 'DD') order by 1 desc;
Archive generated on day to Hourly basis :
select trunc(first_time, 'HH') , count(*) from v$loghist group by trunc(first_time, 'HH') order by 1 desc
No comments:
Post a Comment