Note
This view is available starting with V4.6.0.
Purpose
The GV$OB_SS_LOCAL_CACHE_DIAGNOSE view is used to diagnose the running status of the local cache submodules for all tenants in shared-storage (SS) mode across all OBServer nodes.
Note
This view is only applicable to shared-storage (SS) mode. In shared-nothing (SN) mode, the query result of this view is empty.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| SVR_IP | varchar(46) | NO | The IP address of the node where the replica is located. |
| SVR_PORT | bigint(20) | NO | The port of the node where the replica is located. |
| TENANT_ID | bigint(20) | NO | The tenant ID. |
| MOD_NAME | varchar(64) | NO | The name of the local cache module. |
| SUB_MOD_NAME | varchar(64) | NO | The name of the local cache submodule. |
| STATUS | varchar(7) | NO | The running status of the corresponding submodule:
|
| MODIFY_TIME | timestamp(6) | NO | The timestamp of the last status change of the corresponding submodule. |
| DIAGNOSE_INFO | varchar(1024) | NO | The diagnostic information of the corresponding submodule. |
| EXTRA_INFO | varchar(1024) | NO | The supplementary information about the status of the corresponding submodule. |
Sample query
Query the running status and diagnostic information of all local cache submodules for tenant ID 1004:
obclient(root@sys)[(none)]> SELECT * FROM oceanbase.GV$OB_SS_LOCAL_CACHE_DIAGNOSE WHERE tenant_id=1004;
The query result is as follows:
+--------------+----------+-----------+----------------+--------------+--------+----------------------------+-------------------------------------------------+------------+
| svr_ip | svr_port | tenant_id | mod_name | sub_mod_name | status | modify_time | diagnose_info | extra_info |
+--------------+----------+-----------+----------------+--------------+--------+----------------------------+-------------------------------------------------+------------+
| xx.xx.xx.xx | 11404 | 1004 | ss_micro_cache | micro_cache | NORMAL | 2026-01-12 20:09:28.004202 | valid_micro_cnt: 1608, valid_micro_size: 484085 | |
| xx.xx.xx.xx | 11406 | 1004 | ss_micro_cache | micro_cache | NORMAL | 2026-01-12 20:09:31.872772 | valid_micro_cnt: 162, valid_micro_size: 48170 | |
+--------------+----------+-----------+----------------+--------------+--------+----------------------------+-------------------------------------------------+------------+