1. Home
  2. Knowledge Base
  3. Scripts
  4. Monitoring
  5. Script- Track redo generation by day
  1. Home
  2. Knowledge Base
  3. Scripts
  4. Script- Track redo generation by day

Script- Track redo generation by day


select trunc(completion_time) rundate
,count(*)  logswitch
,round((sum(blocks*block_size)/1024/1024)) "REDO PER DAY (MB)"
from v$archived_log
group by trunc(completion_time)
order by 1;
The following two tabs change content below.

Gavin Soorma

Latest posts by Gavin Soorma (see all)

Updated on June 2, 2021

Was this article helpful?

Related Articles

Comments

  1. It’s a very crisp and neat script, providing the required information.great work mate!

Reply to Rajiv