News
Perth, Australia
+ (61) 417713124
prosolutions@gavinsoorma.com

Script- Track redo generation by day

  • Posted by Gavin Soorma
  • On June 20, 2009
  • 2 Comments
  • ARCHIVELOG, redo, redo per day, v$archived_log

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;
 

2 Comments

Rajiv
  • Jan 19 2011
It's a very crisp and neat script, providing the required information.great work mate!
Karuankar Reddy
  • Feb 20 2017
Good one

Leave Reply

Your email address will not be published. Required fields are marked *