|
The SQL Statement Details dialog has a SQL Statement Details pane and a Query Information pane. Note that the fields displayed vary with the SQL statement selected, so you may not see all the fields that are described below.
SQL statement details The following information is provided for the SQL statement:
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.
Query information The following query information is provided for the SQL statement:
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 or not the optimizer bypass was used.
Actual text plan Shows the actual text plan.
Plan at execution time Shows the plan at execution time. Click an objects to display the details for that object. Click Advanced Details to display more detailed information.