Trace on specific sql_id

SQL> — SQL Trace (10046)
SQL> ALTER SYSTEM SET EVENTS ‘sql_trace [sql:&&sql_id] bind=true, wait=true’;

SQL> — 10053
SQL> ALTER SESSION SET EVENTS ‘trace[rdbms.SQL_Optimizer.*][sql:sql_id]’;

SOURCE:

https://oracle-base.com/articles/misc/sql-trace-10046-trcsess-and-tkprof

https://blogs.oracle.com/optimizer/entry/how_do_i_capture_a

Author: reguchi

Oracle OCP 11g/12c, Oracle OCE Exadata, MySQL DBA, RHCE, technology geek, homebrewer, dad

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s