Purpose
The V$OB_PS_STAT view displays the overall status of the PS cache, including the hit rate, the memory usage, and the number of cached items.
Note
This view is introduced since OceanBase Database V4.0.0.
Columns
Column |
Type |
Nullable? |
Description |
|---|---|---|---|
| TENANT_ID | bigint(20) | NO | The ID of the tenant. |
| SVR_IP | varchar(46) | NO | The IP address of the OBServer node. |
| SVR_PORT | bigint(20) | NO | The port number of the OBServer node. |
| STMT_COUNT | bigint(20) | NO | The number of statements cached in the PS cache. |
| HIT_COUNT | bigint(20) | NO | The total number of PS cache hits. |
| ACCESS_COUNT | bigint(20) | NO | The total number of accesses to the PS cache. |
| MEM_HOLD | bigint(20) | NO | The memory occupied by the PS cache. |