Request ID   Shows the request ID.

SQL statement   Shows the full text of the selected SQL statement. Note that the text displayed for the statement may not match the original text. If this statement was captured after it was parsed by the database server (either because it is part of a compiled database object, such as a stored procedure or trigger, or because it was only selected for inclusion in the trace because it satisfied a sampling or cost condition), it may appear different than it was originally written. In particular, queries over views may appear drastically different since the view definitions are often flattened into the queries (expanded inline).

Host/internal variables   Shows host variables, internal variables, and their values for the selected SQL statement.

Start time   Shows the statement start time.

Duration   Shows the duration of the statement, which is the time the database server spent actually processing the request.

Cursor close time   Shows the cursor close time.

Connection ID   Shows the connection ID for the selected statement.

User   Shows the user ID for the selected statement.

SQL error code   Shows the numerical SQL error code associated with the error.

Procedure/Trigger   Shows the stored procedure or trigger related to the selected statement.

Procedure/Trigger line number   Shows the line number of the applicable procedure or trigger.

Isolation level   Shows the isolation level for the selected statement.

Forward fetches   Shows the number of forward fetches for the selected statement.

Reverse fetches   Shows the number of reverse fetches for the statement.

Absolute fetches   Shows the number of absolute fetches for the statement.

First fetch time   Shows the first fetch time for the selected database.

Used optimizer bypass   Shows whether the optimizer bypass was used.

Actual text plan   Shows the actual text plan.

Plan at build time   Shows the plan at build time. Click an object to display the details for that object. Click Advanced Details to display more details.