Here is a script that I use, which creates a
procedure called logtime. You call it, providing it with a parameter which is
the last x log switches you want to know the time of...
create or replace procedure logtime(p_logs
in number default 20) as
v_no_of_logs number
:=p_logs;
v_buffersize number :=
v_no_of_logs*35;
cursor cur_countlog
is select count(*) cnt from
v$log_history;
cursor cur_gettimes(p_count
number) is select rpad(sequence#,8)
seq,
to_char(first_time,'DD-MON-YYYY:HH24:MI:SS') TIME
from v$log_history where
rownum<=p_count minus select
rpad(sequence#,8) seq,
to_char(first_time,'DD-MON-YYYY:HH24:MI:SS') TIME
from v$log_history where
rownum<=p_count-v_no_of_logs;
begin
dbms_output.enable(v_buffersize);
dbms_output.put_line('SEQ# TIME');
dbms_output.put_line('-----------------------------');
for cur_countlogrec in
cur_countlog loop
for
cur_gettimesrec in cur_gettimes(cur_countlogrec.cnt) loop
<FONT face="Courier New"
size=2>
dbms_output.put_line(cur_gettimesrec.seq||'
'||cur_gettimesrec.time);
end
loop;
end loop;
end;/
Received on Fri Aug 24 2001 - 11:26:37 CDT
