oracle v$recover_file,Oracle归档日志使用情况： v$recovery_file_dest and v$recovery_area_usage....

SQL>  SELECT * FROM V$RECOVERY_AREA_USAGE;

FILE_TYPE            PERCENT_SPACE_USED PERCENT_SPACE_RECLAIMABLE NUMBER_OF_FILES

-------------------- ------------------ ------------------------- ---------------

CONTROL FILE                          0                         0               0

REDO LOG                              0                         0               0

ARCHIVED LOG                      91.91                         0              86

BACKUP PIECE                          0                         0               0

IMAGE COPY                            0                         0               0

FLASHBACK LOG                         0                         0               0

FOREIGN ARCHIVED LOG                  0                         0               0

7 rows selected.

如果超过90%随时有宕机的危险，需删除归档或扩容磁盘，当删除归档文件后需要用RMAN工具释放归档所占用的空间，首先连接RMAN工具