Get Archive log file details in Oracle Database

 How to get archive log file details in Oracle


set linesize 190
col name for a60

SELECT
    SEQUENCE#, 
    NAME, 
    FIRST_TIME AS "First Timestamp", 
    COMPLETION_TIME AS "Completion Timestamp", 
    THREAD#, 
    ARCHIVED
FROM
    V$ARCHIVED_LOG
where name like '%&archive_log_file%'
ORDER BY 
    FIRST_TIME asc;



Comments