PMU 406 PeopleCode SQL Execute

PMU 406 has the following identification attributes.

Attribute

Value

ID

406

Label

PeopleCode SQL Execute

Description

Execution of PeopleCode SQLExec and SQL Objects

Filter Level

PMU 406 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 Origin

SQLExec or SQL Object.

Metrics

Metric

Value

Description

1

Cursor Number

Unique ID for a SQL cursor.

2

PeopleCode Statement Number

PeopleCode statement number (excluding comments and white space).

3

SQL Was Compiled

Boolean - was SQL compiled before executing?

4

SQL Compile Time (ms)

Compile time for this SQL (millisecs).

7

SQL Operation and Tables

SQL Operation and Tables (such as UPDATE PS_QUERY_RUN_QRYVW).

Additional Label

SQL Statement.