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). |