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