====== [HOWTO] Trace any sql ======

====== Original documentation ======
[[https://smarttechways.com/2018/12/10/trace-the-sql-query-with-sql-id-in-oracle/|Trace the SQL Query with SQL ID in Oracle]]

====== Instructions ======

Identify your SQL ID of SQL Query which need to trace.
<code sql>
SELECT sql_id, plan_hash_value, substr(sql_text,1,40) sql_text
FROM v$sql
WHERE sql_text like 'SQL QUERY%';
</code>

Enable the trace of SQL with using ''<SQLID>'' in following statements:
<code sql>
alter system set events 'sql_trace [sql:<SQLID>] wait=true,bind=true';
alter system set events 'trace[sql_optimizer.*] [sql:<SQLID>]';
</code>




\\
Disable tracing:
<code sql>
alter system set events 'sql_trace off';
alter system set events 'trace[sql_optimizer.*] off';
</code>