Wednesday, March 7, 2018

Query to check the amount of archive generation in database



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: