Note
This view is available starting with V4.6.0.
Purpose
The GV$OB_SS_LOCAL_CACHE_DIAGNOSE view is used to diagnose the operation status of the local cache submodules of the current tenant on each OBServer node in shared storage mode.
Note
This view is available only in shared storage (SS) mode. In shared-nothing (SN) mode, the query result is empty.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| SVR_IP | varchar(46) | NO | The IP address of the node where the replica resides. |
| SVR_PORT | bigint(20) | NO | The port of the node where the replica resides. |
| 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 operation status of the corresponding submodule:
|
| MODIFY_TIME | timestamp(6) | NO | The timestamp when the operation status of the corresponding submodule was last changed. |
| DIAGNOSE_INFO | varchar(1024) | NO | The diagnostic information of the corresponding submodule. |
| EXTRA_INFO | varchar(1024) | NO | The supplementary information about the operation status of the corresponding submodule. |
Sample query
Query the operation status and diagnostic information of the local cache submodules of the tenant with tenant ID 1004:
obclient(root@mysql001)[(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 | |
+--------------+----------+-----------+----------------+--------------+--------+----------------------------+-------------------------------------------------+------------+