Oracle教程 2023-02-26

Oracle 视图 DBA_FLASHBACK_ARCHIVE 官方解释，作用，如何使用详细说明

Oracle视图DBA_FLASHBACK_ARCHIVE可用于查询数据库Flashback Archive的相关信息，包含状态、空间等。可用来查询以下信息：

1）Flashback Archive状态：当前是否与Flashback Archive相关联，状态是enable还是disable

2）Flashback Archive空间：Flashback Archive中Flashback动态数据量存放的空间、大小等信息

3）Flashback Archive其它参数：剩余时间、Flashback恢复点指数、Flashback_Scn时间、表空间名等信息

使用方式：

1) 查询正在使用的FBA:

SELECT * FROM DBA_FLASHBACK_ARCHIVE WHERE STATUS=’ENABLED’;

2) 查询

DBA_FLASHBACK_ARCHIVE describes all flashback archives available in the database.

Related View

USER_FLASHBACK_ARCHIVE describes the flashback archives available to the current user.

Column	Datatype	NULL	Description
`OWNER_NAME`	`VARCHAR2(255)`		Name of the creator of the flashback archive
`FLASHBACK_ARCHIVE_NAME`	`VARCHAR2(255)`	`NOT NULL`	Name of the flashback archive
`FLASHBACK_ARCHIVE#`	`NUMBER`	`NOT NULL`	Number of the flashback archive
`RETENTION_IN_DAYS`	`NUMBER`	`NOT NULL`	Maximum duration (in days) for which data is retained in the flashback archive
`CREATE_TIME`	`TIMESTAMP(9)`		Time at which the flashback archive was created
`LAST_PURGE_TIME`	`TIMESTAMP(9)`		Time at which the data in the flashback archive was last purged by the system
`STATUS`	`VARCHAR2(7)`		Indicates whether the flashback archive is a default flashback archive for the system (`DEFAULT`) or not (NULL)