Current executing statements
(INST_ID, SID)
| Name | Data Type | Description |
|---|---|---|
| INST_ID | long | Instance ID |
| SID | long | Session ID |
| SERIAL# | long | Session serial # |
| SQL_CHILD_NUMBER | long | Child # for the SQL; one SQL statement may have multiple child cursors due to environment differences between sessions |
| ELAPSED_TIME_S | long | Elapsed time, in seconds |
| START_TIME | time | Start time of statement |
| USERNAME | string(32) | User name |
| SQL_ID | string(16) | SQL ID |
| SQL_TEXT | string(68) | SQL text preview |
| Attributes: | None |
|---|---|
| Minimum database version: | 9.2 |