PMU 400 Tuxedo Service PCode and SQL

PMU 400 has the following identification attributes.

Attribute

Value

ID

400

Label

Tuxedo Service PCode and SQL

Description

Current SQL and PeopleCode and SQL summary metrics

Filter Level

PMU 400 has a filter level of 4.

Sampling Enabled

Yes.

Contexts

Context

Value

Description

1

Generic

Generic - Varies based upon server and service request.

2

Server Name

Server Name (such as PSAPPSRV, PSQRYSRV, PSSAMSRV).

3

Tuxedo Service Name

Tuxedo Service Name (such as ICPanel, ICScript, and so on).

Metrics

Metric

Value

Description

1

PeopleCode Exec Time (ms)

PeopleCode execution time (milliseconds).

2

PeopleCode SQL Time (ms)

Execution Time for SQLExec and SQL object (milliseconds).

3

PCode BuiltIn SQL Time (ms)

Total PeopleCode BuiltIn SQL Execution Time(milliseconds).

4

PeopleTools SQL Time (ms)

SQL time excluding PeopleCode and BuiltIn SQL (milliseconds).

5

SQL Fetch Count

Total number of rows fetched from the database.

6

SQL Execute Count

SQL Execute Count.

7

Trace Level

SQL, PeopleCode, and Component Processor trace levels.

Additional Label

Current SQL statement.