Query To Check Archive Log Generation Per Hour
Asked By
0 points
N/A
Posted on - 06/29/2019
I want to check my hourly archive log generation in my database and sql. How can I do so? What is the query to be used for the same?
I want to check my hourly archive log generation in my database and sql. How can I do so? What is the query to be used for the same?
Your query can be generated for the requirements of hourly archive log details you just have to use the given query.
set pages 1000
alter session set nls_date_format = ‘YYYY-MON-DD HH24:MI:SS’;
select trunc(COMPLETION_TIME,’HH’) Hour,thread# ,
round(sum(BLOCKS*BLOCK_SIZE)/1024/1024/1024) GB,
count(*) Archives from v$archived_log
group by trunc(COMPLETION_TIME,’HH’),thread# order by 1 ;
this query will let you know the required logs.