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 theV$TRUE_CACHE
view.
Parent topic: Monitoring True Cache