Purpose
v$ps_stat displays the overall status of the PS cache, including the hit rate, the memory usage, and the number of cached items.
Fields
| Field | Type | Nullable? | Description |
|---|---|---|---|
| tenant_id | bigint(20) | NO | The ID of the tenant. |
| svr_ip | varchar(32) | NO | The IP address of the server. |
| svr_port | bigint(20) | NO | The port number of the server. |
| 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. |