Note
This view was introduced in OceanBase Database V4.3.4.
Purpose
This view displays the metrics of various types of cached data in the local cache of all tenants on the current OBServer node in shared storage mode.
Note
This view applies only 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 | IP address of the OBServer node |
| SVR_PORT | bigint(20) | NO | Port number of the OBServer node |
| TENANT_ID | bigint(20) | NO | ID of the tenant |
| CACHE_NAME | varchar(128) | NO | Name of a type of cached data in the local cache, which can be one of the following types:
|
| PRIORITY | bigint(20) | NO | Cache priority. A higher value indicates a higher priority. This field is currently unused and has a default value of 0. |
| HIT_RATIO | decimal(38,3) | NO | Cache hit ratio |
| TOTAL_HIT_CNT | bigint(20) | NO | Total number of cache hits |
| TOTAL_MISS_CNT | bigint(20) | NO | Total number of cache misses |
| HOLD_SIZE | bigint(20) | NO | Total size of objects stored in the cache, in bytes |
| ALLOC_DISK_SIZE | bigint(20) | NO | Allocated disk space, in bytes |
| USED_DISK_SIZE | bigint(20) | NO | Used disk space (disk space allocated but not used), in bytes |
| USED_MEM_SIZE | bigint(20) | NO | Used memory space, in bytes |