Purpose
gv$ps_item_info displays the monitoring information of prepared statements, including the basic information of all prepared statements in the PS cache.
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_id | bigint(20) | NO | The ID of the corresponding statement in the PS cache. |
| db_id | bigint(20) | NO | The database ID in the prepared statement. |
| ps_sql | varchar(65536) | NO | The SQL information of the prepared statement. |
| param_count | bigint(20) | NO | The number of parameters in the prepared statement. |
| stmt_item_ref_count | bigint(20) | NO | The reference count of stmt_item. |
| stmt_info_ref_count | bigint(20) | NO | The reference count of stmt_info. |
| mem_hold | bigint(20) | NO | The size of memory occupied by the prepared statement. |
| stmt_type | bigint(20) | NO | The type of the prepared statement. |
| checksum | bigint(20) | NO | The checksum of the prepared statement. |