v$database.arch_mode字段查看归档状态，V$DM_ARCH_INI视图查看归档的详细信息包括归档文件大小、空间限制、归档位置、归档类型等

select name,arch_mode from v$database;

归档日志大小可以查看v$arch_file.len字段

select DB_MAGIC,pmnt_magic,status,create_time,close_time,path,round(len/1024/1024,2) ARCH_MB FROM V$ARCH_FILE ORDER BY CREATE_TIME;

1.查看是否处于归档模式
select CASE WHEN ARCH_MODE ='Y' THEN '归档模式' ELSE '非归档模式' END from v$database;

2.查询归档配置（归档路径，单个文件大小，归档上限）
select ARCH_DEST AS "归档路径", ARCH_FILE_SIZE AS "归档文件单个大小（MB）" , ARCH_SPACE_LIMIT AS "归档上限（MB)" from v$dm_arch_ini where arch_type='LOCAL';

3.查询当前归档日志总大小
SELECT ROUND(SUM(LEN) / 1024.0 / 1024,2) AS "当前归档总大小（MB)" FROM V$ARCH_FILE;