V$RESTORE_POINT – displays information about restore points.

V$TABLESPACE – query the FLASHBACK_ON column to find whether the flashback logging is enabled or not for a specific tablespace.

V$DATABASE – query the FLASHBACK_ON column to find whether the Flashback Database feature is enabled or not at the database level.

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.

V$ARCHIVED_LOG, V$LOG_HISTORY, GV$ARCHIVED_LOG, GV$LOG_HISTORY – displays archived log information from the control file, including archive log names.

Here you can view the percentage of FRA that is used from every type of file including flashback log files.

V$FLASH_RECOVERY_AREA_USAGE – displays usage information about flashback recovery areas separated by file types.

Here you can find the start SCN for every flashback log file.

V$FLASHBACK_DATABASE_LOGFILE, GV$FLASHBACK_DATABASE_LOGFILE (for RAC) – display detailed info about flashback log files.

Here you can find the space limit and currently used space in FRA.

V$RECOVERY_FILE_DEST – displays information about the disk quota and current disk usage in the flash recovery area.

This view also displays the estimated flashback space needed based on previous workloads.

V$FLASHBACK_DATABASE_STAT, GV$FLASHBACK_DATABASE_STAT (for RAC) – displays statistics for monitoring the I/O overhead of logging flashback data.

Use this view to help estimate the amount of flashback space required for the current workload.

V$FLASHBACK_DATABASE_LOG, GV$FLASHBACK_DATABASE_LOG (for RAC) – displays information about the flashback data.

V$ASM_DISKGROUP – Informações sobre os DISKGROUPS criados no ASM.

(Para pegar algum disco possivelmente em falha ou elegível a ser utilizado.)

V$ASM_DISK – Informações sobre os discos ASM.

Stickers para whatsapp de batman