oracle 9i archived logs 1

[alex77ander]

I am trying to find a way to report the number of archive logs produced by the hour by day.

 

[KenCunningham]

Within Oracle or the Operating System (if the latter, which)?

I want to be good, is that not enough?

 

[SantaMufasa]

Alex,

I find that information by simply doing an "ls -l" (Unix) or "dir" (Windows) on the archive log directory and counting the number of archive log files during the period I want to survey. Another way is to examine the alert log to see the number of log switches within a timestamp range.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[karluk]

One way to do this is to query v$archived_log. The following query will list the number of archived logs produced each hour of the day yesterday.

select to_char(completion_time,'yyyy/mm/dd hh24'), count(*) from v$archived_log
  where completion_time between trunc(sysdate-1) and trunc(sysdate)
  group by to_char(completion_time,'yyyy/mm/dd hh24')
  order by 1