5.1 Monitoring True Cache with the V$TRUE_CACHE View

Use the V$TRUE_CACHE view to monitor the overall relationship and health of a True Cache configuration.

You can query the V$TRUE_CACHE view on the primary database and True Cache. On True Cache, the view displays a single row for the primary database that it connects to. On the primary database, the view shows one row for each True Cache that's connected to the primary database. Each row displays the status for the True Cache.

To use this view, enter the following query:

SELECT * FROM v$true_cache;

The following example shows output on True Cache:

MY_DG_ID   REMOTE_DG_ID DEST_ID TRUE_CACHE_NAME PRIMARY_NAME STATUS  REMOTE_VERSION CON_ID
---------- ------------ ------- --------------- ------------ ------- -------------- ------
2976625076    626116455       0 TCDB1           PRIMARYD     HEALTHY 23.0.0.0.0          0

The following example shows output on a primary database:

MY_DG_ID  REMOTE_DG_ID DEST_ID TRUE_CACHE_NAME PRIMARY_NAME STATUS  REMOTE_VERSION  CON_ID
--------- ------------ ------- --------------- ------------ ------- --------------  ------
626116455   2976625076       2 TCDB1           PRIMARYD     HEALTHY 23.0.0.0.0           0
626116455   2499211322       3 TCDB2           PRIMARYD     HEALTHY 23.0.0.0.0           0

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