Note
This view was introduced in OceanBase Database V4.3.4.
Purpose
This view displays the metrics of various types of cache data in the local caches 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 | VARCHAR2(46) | NO | The IP address of the OBServer node. |
| SVR_PORT | NUMBER(38) | NO | The port of the OBServer node. |
| TENANT_ID | NUMBER(38) | NO | The ID of the tenant. |
| CACHE_NAME | VARCHAR2(128) | NO | The name of a type of data cached in the local cache. Valid values include:
|
| PRIORITY | bigint(20) | NO | The priority of the cache. The higher the value, the higher the priority. This field is currently unused, and the default value is 0. |
| HIT_RATIO | NUMBER(38,3) | NO | The cache hit ratio. |
| TOTAL_HIT_CNT | NUMBER(38) | NO | The total number of cache hits. |
| TOTAL_MISS_CNT | NUMBER(38) | NO | The total number of cache misses. |
| HOLD_SIZE | NUMBER(38) | NO | The total size of objects stored in the cache, in bytes. |
| ALLOC_DISK_SIZE | NUMBER(38) | NO | The allocated disk space, in bytes. |
| USED_DISK_SIZE | NUMBER(38) | NO | The used disk space (which may be zero if the disk space has been allocated but not used), in bytes. |
| USED_MEM_SIZE | NUMBER(38) | NO | The used memory space, in bytes. |