PMU 414 SQL Fetch Summary
PMU 414 has the following identification attributes.
Attribute |
Value |
---|---|
ID |
414 |
Label |
SQL Fetch Summary |
Description |
Metrics for all SQL fetches for parent SQL (406, 407, 408) |
Filter Level
PMU 414 has a filter level of 5.
Sampling Enabled
Yes.
Contexts
Context |
Value |
Description |
---|---|---|
1 |
Generic |
Generic - Varies based upon server and service request. |
2 |
PeopleCode Program |
PeopleCode Program name. |
3 |
SQL Fetch Origin |
SQL Fetch Origin. |
Note: Context 2 and Context 3 are populated only for PeopleCode and SQL built-in functions.
Metrics
Metric |
Value |
Description |
---|---|---|
1 |
SQL Fetch Time (ms) |
SQL fetch time. |
2 |
Cursor Number |
Unique ID for a SQL cursor. |
3 |
SQL Fetch Count |
Total number of rows fetched from the database. |
7 |
SQL Operation and Tables |
SQL Operation and Tables (such as UPDATE PS_QUERY_RUN_QRYVW). |