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 |
|---|---|---|---|
| SVR_IP | VARCHAR2(46) | NO | The IP address of the server. |
| SVR_PORT | NUMBER(38) | NO | The port number of the server. |
| STMT_COUNT | NUMBER(38) | NO | The number of statements cached in the PS cache. |
| HIT_COUNT | NUMBER(38) | NO | The total number of PS cache hits. |
| ACCESS_COUNT | NUMBER(38) | NO | The total number of accesses to the PS cache. |
| MEM_HOLD | NUMBER(38) | NO | The memory occupied by the PS cache. |