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 hash 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 hash 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
`CURRENT_SCN`	`NUMBER`	Current SCN When queried on a True Cache, the SCN of the primary database from the last time the True Cache SCN was refreshed When queried on a primary database, the SCN 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 AI Database 26ai.