ORACLE – Monitorando a área de Flashback e Archivelog

• V$ASM_DISK – Informações sobre os discos ASM. (Para pegar algum disco possivelmente em falha ou elegível a ser utilizado.)
• V$ASM_DISKGROUP – Informações sobre os DISKGROUPS criados no ASM.
• V$FLASHBACK_DATABASE_LOG, GV$FLASHBACK_DATABASE_LOG (for RAC) – displays information about the flashback data. Use this view to help estimate the amount of flashback space required for the current workload.
• V$FLASHBACK_DATABASE_STAT, GV$FLASHBACK_DATABASE_STAT (for RAC) – displays statistics for monitoring the I/O overhead of logging flashback data. This view also displays the estimated flashback space needed based on previous workloads.
• V$RECOVERY_FILE_DEST – displays information about the disk quota and current disk usage in the flash recovery area. Here you can find the space limit and currently used space in FRA.
• V$FLASHBACK_DATABASE_LOGFILE, GV$FLASHBACK_DATABASE_LOGFILE (for RAC) – display detailed info about flashback log files. Here you can find the start SCN for every flashback log file.
• V$FLASH_RECOVERY_AREA_USAGE – displays usage information about flashback recovery areas separated by file types. Here you can view the percentage of FRA that is used from every type of file including flashback log files. This view is available in 10g R2 only.
• V$ARCHIVED_LOG, V$LOG_HISTORY, GV$ARCHIVED_LOG, GV$LOG_HISTORY – displays archived log information from the control file, including archive log names. You can use it check availability of the needed archived redo log files before starting of a Flashback Database operation.
• V$LOGFILE, V$LOG, GV$LOGFILE, GV$LOG – displays information about redo log files. You can use it check availability of the needed archived redo log files before starting of a Flashback Database operation.
• V$DATABASE – query the FLASHBACK_ON column to find whether the Flashback Database feature is enabled or not at the database level
• V$TABLESPACE – query the FLASHBACK_ON column to find whether the flashback logging is enabled or not for a specific tablespace
• V$RESTORE_POINT – displays information about restore points. Here you can find the map between a specific restore point, SCN and TIMESTAMP value.
• V$SGAINFO – to find the current size of the redo log buffer, fixed SGA and the granule.
• V$SGASTAT – displays detailed information on the SGA and its structures.

Source: http://www.club-oracle.com/threads/monitoring-of-flashback-database-with-data-dictionary-views.16144/

Ainda no mesmo contexto, segue alguns exemplos de SQL’s úteis para o dia a dia:

Listar discos do ASM:

select name,path,failgroup,header_status,disk_number from v$asm_disk;

Verificar o espaço utilizado pelos seus discos ASM:

SELECT name,free_mb,total_mb FROM v$asm_diskgroup;

Verificar o Espaço utilizado pelo Archivelog e pelo Flashback:

select (space_used/1048576),(space_limit/1048576) from v$recovery_file_dest;