SQL Trace

After running SQL, The users can check the detailed execution information of the executed SQL. The users can analyze and tune the performance of SQL through the trace information.

Figure 1. SQL Trace - Statistics

Figure 2. SQL Trace - Predicate Information

The SQL Trace feature provides the following information.

Predicate Name	Description
SQL	The SQL that was run
SQL ID	The SQL ID of the SQL that was run.
CHILD NUMBER	CHILD NUMBER of the executed SQL
plan hash value	PLAN HASH VALUE of the executed SQL
Autotrace Stats	Shows statistical information of the executed SQL.
Plan Stats	Shows detailed information for each step of the execution plan.
Remote SQL Information	Shows SQL information related to remote databases.
Logical Plan Information	Displays logical execution plan information.
Predicate Information	Shows detailed information about filtering conditions (WHERE clause, JOIN condition, etc.) of SQL statements.
Note Information	Shows additional notes related to the execution plan.
SQL Plan	The execution plan for SQL.