Query To Check Archive Log Generation Per Hour

Asked By Dornfest Rael 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?

• Status: Open
• Question Views: 65
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Others
• Question Tags: log

Answered By Peter Gonzalez 30 points N/A #318795

Query To Check Archive Log Generation Per Hour

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.

About Peter Gonzalez

Questions
25

Answers
2

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 06/29/2019
• Question Category: Others