Friday, January 22, 2010

Archive logs per day

How many archive logs do you generate a day?



select COMPLETION_TIME, NAME from v$archived_log
order by COMPLETION_TIME



And do some funky group by if you want.

******************************************
keywords: archive log day
******************************************
rdbms version: 10g
******************************************

No comments: