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 each OBServer node in shared storage mode for the current tenant.
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 | The IP address of an OBServer node. |
| SVR_PORT | bigint(20) | NO | The port number of an OBServer node. |
| TENANT_ID | bigint(20) | NO | The ID of the tenant. |
| CACHE_NAME | varchar(128) | NO | The name of a type of cached data in the local cache. The following types are supported:
|
| PRIORITY | bigint(20) | NO | The cache priority. A higher value indicates a higher priority. This field is currently unused and the value is set to 0 by default. |
| HIT_RATIO | decimal(38,3) | NO | The cache hit ratio. |
| TOTAL_HIT_CNT | bigint(20) | NO | The total number of cache hits. |
| TOTAL_MISS_CNT | bigint(20) | NO | The total number of cache misses. |
| HOLD_SIZE | bigint(20) | NO | The total size of objects in the cache, in bytes. |
| ALLOC_DISK_SIZE | bigint(20) | NO | The allocated disk space, in bytes. |
| USED_DISK_SIZE | bigint(20) | NO | The used disk space (which may not be used after being allocated), in bytes. |
| USED_MEM_SIZE | bigint(20) | NO | The used memory space, in bytes. |