Operating System - HP-UX
1748180 Members
3947 Online
108759 Solutions
New Discussion юеВ

Re: Which view tells about last applied archivelog

 
SOLVED
Go to solution
ezhilarasan_1
Occasional Advisor

Which view tells about last applied archivelog

Hi,

Which dictionary view tells about last
applied archivelog ?

Thanks
R.Ezhil
2 REPLIES 2
Brian Crabtree
Honored Contributor

Re: Which view tells about last applied archivelog

v$loghist will show you the last successful archivelog generated. You can also look at the v$log view which will show you what each log group is on, what has been archived, and what is current.

select * from v$loghist where sequence# = (select max(sequence#) from v$loghist);

Thanks,

Brian
twang
Honored Contributor
Solution

Re: Which view tells about last applied archivelog

v$log_history, you may determine how much space is needed for the archive files using v$log_history:
select MAX(first_time) ord, to_char(first_time,'DD-MON-YYYY') date_, count(recid) no, count(recid) * no_size
from v$log_history
group by to_char(first_time,'DD-MON-YYYY') order by ord