Purpose
The V$OB_PS_ITEM_INFO view displays the monitoring information about prepared statements, including the basic information about all prepared statements in the PS cache.
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_ID | NUMBER(38) | NO | The ID of the corresponding statement in the PS cache. |
| DB_ID | NUMBER(38) | NO | The database ID in the prepared statement. |
| PS_SQL | CLOB | NO | The SQL information about the prepared statement. |
| PARAM_COUNT | NUMBER(38) | NO | The number of parameters in the prepared statement. |
| STMT_ITEM_REF_COUNT | NUMBER(38) | NO | The reference count of stmt_item. |
| STMT_INFO_REF_COUNT | NUMBER(38) | NO | The reference count of stmt_info. |
| MEM_HOLD | NUMBER(38) | NO | The size of memory occupied by the prepared statement. |
| STMT_TYPE | NUMBER(38) | NO | The type information of the prepared statement. |
| CHECKSUM | NUMBER(38) | NO | The checksum of the prepared statement. |
| EXPIRED | NUMBER(38) | NO | Indicates whether the prepared statement has expired. |