10.145 V$TRUE_CACHE

V$TRUE_CACHE displays True Cache configuration information.

  • When you query this view on a True Cache, it returns a single row of information about the primary database to which the True Cache is connected.

  • When you query this view on a primary database, it returns one row of information for each True Cache that is connected to the primary database.

Column Datatype Description

MY_DG_ID

NUMBER

Data Guard ID

  • When queried on a True Cache, the Data Guard ID of the True Cache

  • When queried on a primary database, the Data Guard ID of the primary database

REMOTE_DG_ID

NUMBER

Remote Data Guard ID

  • When queried on a True Cache, the Data Guard ID of the primary database

  • When queried on a primary database, the Data Guard ID of the True Cache

DEST_ID

NUMBER

Log archive destination parameter identifier

  • When queried on a True Cache, the value of this column is always 0, because a True Cache does not send online redo log blocks to any destination.

  • When queried on a primary database, the corresponding destination ID (n) of the LOG_ARCHIVE_DEST_n initialization parameter. This parameter specifies the network name of the True Cache so that the primary database knows where to send online redo log blocks.

This column matches the DEST_ID column in other views related to Data Guard and redo transport services, such as the V$ARCHIVE_DEST and V$DATAGUARD_STATUS views.

TRUE_CACHE_NAME

VARCHAR2(30)

Unique database name (DB_UNIQUE_NAME) of the True Cache

PRIMARY_NAME

VARCHAR2(30)

Unique database name (DB_UNIQUE_NAME) of the primary database

STATUS

VARCHAR2(256)

Text describing the current status of the True Cache configuration

If there is an issue with the True Cache configuration, then this column displays information about the issue.

If there are no issues with the True Cache configuration, then the value of this column is HEALTHY.

REMOTE_VERSION

VARCHAR2(18)

Remote database version

  • When queried on a True Cache, the database version of the primary database

  • When queried on a primary database, the database version of the True Cache

CON_ID

NUMBER

The ID of the container to which the data pertains

The value of this column is always 0 (CDB$ROOT container).

Note:

This view is available starting with Oracle Database 23ai.