arc_status

col NAME for a80
col STATUS for a20
select *
from (
select first_time,next_time ,COMPLETION_TIME,sequence# ,FIRST_CHANGE#,NEXT_CHANGE#,
--  NAME Name1,
case when length(name) < 12 then Name when substr(name, 1,1) ='+' then substr(name, 1,65)||'...' when length(name) > 12 then substr(name, 1,65)||'...' END NAME , case when STATUS='A' then 'Available' when STATUS='D' then 'Deleted' when STATUS='U' then 'Unavailable' when STATUS='X' then 'Expired' else STATUS END STATUS, REGISTRAR, ARCHIVED,APPLIED, DELETED
from v$archived_log order by first_time desc )
where rownum < 500 order by first_time asc;