Application Engine Call Structure

This image illustrates the Application Engine call structure in Log Analyzer:

Application Engine Call Structure in Log Analyzer

By using the Log Analyzer for Application Engine, you can display the application engine call structure as a tree structure in a table panel. The table panel displays the following log information:

Term Definition

AE Step

The Application Engine Step column displays the Application Engine steps executed in the AE process.

Action Type

The Action Type column displays the Application Engine action type performed in the Application Engine step. Application Engine action types can be any one of the following:

  • Call Section

  • SQL

  • PeopleCode

  • Log Message

  • Do When

  • Do While

  • Do Select

  • Do Until

Time

The Time column displays the time at which the Application Engine action was executed.

Duration

Displays the duration of the action.

Action

The action column displays the SQL action that was performed in the Application Engine step. SQL actions can be any one of the following:

  • INSERT

  • UPDATE

  • SELECT

  • DELETE

Table Name

The Table Name column displays the name of the table in which the action was performed.

Rows

The Rows column displays the number of rows that were updated by the action.

SQL ID

The SQL ID column displays the performance details of the Application Engine step.

The SQL ID column displays a unique identifier of the SQL statement when run on Oracle databases. This is useful for Application Engine SQL performance analysis.

Note: SQL ID is specific to Oracle database so this column is only displayed when we are analyzing an AET file generated against an Oracle database.

Full SQL Text

The Full SQL Text column displays the full SQL text that was run for the SQL action.