8.245 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 Database 23ai.