V$CLONEDFILE

V$CLONEDFILE provides CloneDB file information.


Column Datatype Description

SNAPSHOTFILENAME

VARCHAR2(513)

Snapshot/master file name. This file is the master file from the master database. The snapshot file is also sometimes referred to as the srcfile.

CLONEFILENAME

VARCHAR2(513)

CloneDB file name. This file is the cloned file (of master file) which resides in the current (cloned database). The cloned file is sometimes referred to as the destfile.

SNAPSHOTBLKREAD

NUMBER

Number of blocks reads to the snapshot file (master file)

SNAPSHOTREQUEST

NUMBER

Number of read requests to the snapshot file (master file)

FILENUMBER

NUMBER

File number of the cloned file

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

BLOCKS_ALLOCATED1

NUMBER

Amount of space allocated in blocks in the file system. This is less than or equal to the actual file size.


1

This column is available starting with Oracle Database 12c Release 1 (12.1.0.2).