Search notes:

Oracle Event 10513

The 10053 trace documents the considarations made and decisions taken by the optimizer.

Compare with dbms_sqldiag.dump_trace which also produces a 10053 trace, but does not execute the SQL statement.

Tracing a given SQL statement

The following command traces a given SQL statement (identified by an SQL-id such as 68maq1b045ms3):

alter session set events 'trace[rdbms.SQL_Optimizer.*][sql:68maq1b045ms3]

alter session set events 'trace[rdbms.SQL_Optimizer.*] off;