V$FLASHBACK_DATABASE_LOG &&…

V$FLASHBACK_DATABASE_LOG 和 V$FLASHBACK_DATABASE_STAT

记录一下ORACE 10g  1Z0-043 中关于闪回的两个视图

SQL> col object_name for a30;
SQL>
SQL> select o.object_name, o.object_type
  2    from dba_objects o
  3   where o.object_name like 'V$FLASH%';

OBJECT_NAME                                         OBJECT_TYPE
------------------------------                       -------------------
V$FLASHBACK_DATABASE_LOG                             SYNONYM
V$FLASHBACK_DATABASE_LOGFILE                         SYNONYM
V$FLASHBACK_DATABASE_STAT                            SYNONYM
V$FLASHBACK_TXN_GRAPH                                SYNONYM
V$FLASHBACK_TXN_MODS                                 SYNONYM
V$FLASH_RECOVERY_AREA_USAGE                          SYNONYM

V$FLASHBACK_DATABASE_LOG
显示闪回数据的信息，用来评估当前负载下需要的闪回空间

v$flashback_database_log
Name