Note
This view is available starting with V4.6.0.
Purpose
The V$OB_SS_LOCAL_CACHE_DIAGNOSE view is used to diagnose the running status of local cache submodules for the current tenant on the current OBServer node in the shared storage mode.
Note
This view is applicable only to the shared storage (SS) mode. In the 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 1004:
obclient(root@mysql001)[(none)]> SELECT * FROM oceanbase.V$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 | |
+--------------+----------+-----------+----------------+--------------+--------+----------------------------+-------------------------------------------------+------------+