Cached statement statistics
Columns
| Name |
Description |
| Inst ID |
Instance ID; 0 = non-CE |
| Login |
Login name |
| SQL Text |
SQL text preview |
| Use Count |
Total number of times the statement was used after being cached |
| Cur/Max Concurrent Usage |
Number of active queries for the statement /
Maximum number of simultaneous queries for the statement |
| Avg Elapsed Time |
Average elapsed time per statement execution |
| Min Elapsed Time |
Minimum elapsed time per statement execution |
| Max Elapsed Time |
Maximum elapsed time per statement execution |
| Avg CPU Time |
Average CPU time per statement execution |
| Min CPU Time |
Minimum CPU time per statement execution |
| Max CPU Time |
Maximum CPU time per statement execution |
| Avg LIO |
Average logical I/Os per statement execution |
| Min LIO |
Minimum logical I/Os per statement execution |
| Max LIO |
Maximum logical I/Os per statement execution |
| Avg PIO |
Average physical I/Os per statement execution |
| Min PIO |
Minimum physical I/Os per statement execution |
| Max PIO |
Maximum physical I/Os per statement execution |
| Last Used |
Time when the statement was last used |
| Last Recompiled |
Time when the statement was last recompiled |
| Database |
Database name |
| Parallel Degree |
Degree of parallelism |
Entity Requirements
| Attributes: |
MDA (and no CE or CEINST) |
| Minimum database version: |
15.0.2 |