Note
This view was introduced in OceanBase Database V4.3.4.
Purpose
This view displays the relevant metrics of various types of cache data in the local cache of the current tenant 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 | Tenant ID |
| CACHE_NAME | varchar(128) | NO | Name of a type of data cached in the local cache. The following types of data are supported:
|
| PRIORITY | bigint(20) | NO | Cache priority. The higher the value, the higher the priority. This field is currently unused and the default value is 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 (the disk space may not be used after it is allocated), in bytes |
| USED_MEM_SIZE | bigint(20) | NO | Used memory space, in bytes |