5.1.1 V$TRUE_CACHE Columns

The following table describes the columns in the V$TRUE_CACHE view.

Table 5-1 V$TRUE_CACHE Columns

Column Description
MY_DG_ID The Data Guard ID (DGID) that uniquely identifies the True Cache or primary database in the True Cache configuration.
REMOTE_DG_ID On True Cache, this is the primary database’s DGID. On the primary database, it's the True Cache DGID.
DEST_ID On True Cache, this is always 0. On the primary database, it's the corresponding destination ID (n) of the LOG_ARCHIVE_DEST_n initialization parameter. The LOG_ARCHIVE_DEST_n initialization parameter specifies the network name of the True Cache so that the primary database knows where to send online redo log blocks.
TRUE_CACHE_NAME The unique name of the True Cache (DB_UNIQUE_NAME in the PFILE).
PRIMARY_NAME The unique name of the primary database (DB_UNIQUE_NAME in the PFILE).
STATUS

Describes the current status of the True Cache. If no issues are found, it displays HEALTHY. Otherwise, it displays an error description. For example: ORA-01034: The Oracle instance is not available for use. Start the instance.

REMOTE_VERSION On True Cache, this is the database version of the primary database. On the primary database, this is the database version of the True Cache.
CON_ID The root container ID.

Related Topics