General
cancel
Showing results for 
Search instead for 
Did you mean: 

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
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