Overview
v$ps_item_info displays monitoring information of prepared statements, including the basic information of all prepared statements in the prepared statement cache.
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_id | BIGINT(20) | No | The ID of the corresponding statement in the PS cache. |
| db_id | BIGINT(20) | No | The database ID in the PREPARE statement. |
| ps_sql | varchar(65536) | No | The SQL information of the PREPARE statement. |
| param_count | BIGINT(20) | No | The number of parameters in the PREPARE 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 PREPARE statement. |
| stmt_type | BIGINT(20) | No | The type of the PREPARE statement. |
| checksum | BIGINT(20) | No | The checksum of the PREPARE statement. |