Query To Check Archive Log Generation Per Hour

Asked By 0 points N/A Posted on -
qa-featured

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?

SHARE
Answered By 30 points N/A #318795

Query To Check Archive Log Generation Per Hour

qa-featured

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.

Related Questions