V$FLASHBACK_LOG_DEST

V$FLASHBACK_LOG_DEST displays information about the disk quota and current disk usage for the flashback database log storage area.

Column	Datatype	Description
NAME	VARCHAR2(513)	Location of the flashback database log storage area This value is specified by the DB_FLASHBACK_LOG_DEST initialization parameter.
SPACE_LIMIT	NUMBER	Maximum amount of disk space (in bytes) that the database can use for the flashback database log storage area This is the value specified by the DB_FLASHBACK_LOG_DEST_SIZE initialization parameter.
SPACE_USED	NUMBER	Amount of disk space (in bytes) currently used by flashback database log files in the flashback database log storage area
NUMBER_OF_FILES	NUMBER	Number of files currently in the flashback database log storage area
CON_ID	NUMBER	The ID of the container to which the data pertains. Possible values include: 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs. 1: This value is used for rows containing data that pertain to only the root n: Where n is the applicable container ID for the rows containing data

Note: This view is available starting with Oracle AI Database 26ai.

See Also:

• “DB_FLASHBACK_LOG_DEST”

• “DB_FLASHBACK_LOG_DEST_SIZE”