Lets try to learn basic queries useful for Oracle database administration.
Tuesday, July 29, 2014
Query to find number of archives generated each day
select to_char(completion_time,'dd-mon-yyyy'),count(*) from v$archived_log group by to_char(completion_time,'dd-mon-yyyy') order by to_char(completion_time,'dd-mon-yyyy')
/
No comments:
Post a Comment