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 the current tenant on the current OBServer node in shared storage mode.
Note
This view applies only to shared storage (SS) mode. If the query is performed in shared-nothing (SN) mode, the query result 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 cached data in the local cache. Valid values include:
|
| PRIORITY | bigint(20) | NO | The cache priority. A higher value indicates a higher priority. This field is not used currently 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 (the disk space may not be used after it is allocated), in bytes. |
| USED_MEM_SIZE | NUMBER(38) | NO | The used memory space, in bytes. |