Current executing statements
Columns
| Name |
Description |
| Session ID |
Session ID |
| Serial # |
Session serial # |
| Elapsed Time |
Elapsed time, in seconds |
| Start Time |
Start time of statement |
| Login |
User name |
| SQL Text |
SQL text preview |
| SQL ID |
SQL ID |
| Child # |
Child # for the SQL; one SQL statement may have multiple child cursors due to environment differences between sessions |
SQL Plan - Columns
| Name |
Description |
| ID |
ID # of the SQL plan step |
| Parent |
Parent ID # of the SQL plan step |
| Query Plan |
Text of the SQL plan step |
| % Time |
% of total elapsed time, in last execution; use this to find bottlenecks in the query plan |
| Output Rows |
Number of output rows for the SQL plan step, since instance started |
| Est Bytes |
Internal estimate of the output size (bytes), of the SQL plan step |
| Disk Reads |
Number of physical disk reads, in the last execution |
| Disk Writes |
Number of physical disk writes, in the last execution |
| Est Card |
Internal cardinality (number of output rows) estimate of the SQL plan step |
| Est Cost |
Internal cost estimate of the SQL plan step |
| Access Predicates |
Access predicates |
| Filter Predicates |
Filter predicates |
Entity Requirements
| Attributes: |
None |
| Minimum database version: |
9.2 |