Note
This view is available starting with V4.6.0.
Purpose
The V$OB_SS_LOCAL_CACHE_DIAGNOSE view is used to diagnose the runtime status of the local cache submodules for all tenants in shared-storage (SS) mode on the current OBServer node.
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 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 runtime 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 additional information of the corresponding submodule status. |
Sample query
Query the runtime status and diagnostic information of the local cache submodules for the tenant with ID 1004:
obclient(root@sys)[(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 | |
+--------------+----------+-----------+----------------+--------------+--------+----------------------------+-------------------------------------------------+------------+