Overview
v$ps_stat displays the overall status of the PS cache, including the hit rate, the memory usage, and the number of cached items.
Field description
| Field name | Type | Nullable | Description |
|---|---|---|---|
| tenant_id | BIGINT(20) | No | The ID of the tenant. |
| svr_ip | varchar(32) | No | The IP address of the OBServer. |
| svr_port | BIGINT(20) | No | The port number of the OBServer. |
| 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. |