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:
Post a Comment