dba:oracle:howtos:howto_trace_sql
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revision | Last revisionBoth sides next revision | ||
dba:oracle:howto_trace_sql [2022/02/11 11:12] – ↷ Page moved from oracle:howto_trace_sql to dba:oracle:howto_trace_sql dodger | dba:oracle:howtos:howto_trace_sql [2023/01/31 08:26] – removed - external edit (Unknown date) 127.0.0.1 | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ====== [HOWTO] Trace any sql ====== | ||
- | |||
- | ====== Original documentation ====== | ||
- | [[https:// | ||
- | |||
- | ====== Instructions ====== | ||
- | |||
- | Identify your SQL ID of SQL Query which need to trace. | ||
- | <code sql> | ||
- | SELECT sql_id, plan_hash_value, | ||
- | FROM v$sql | ||
- | WHERE sql_text like 'SQL QUERY%'; | ||
- | </ | ||
- | |||
- | Enable the trace of SQL with using ''< | ||
- | <code sql> | ||
- | alter system set events ' | ||
- | alter system set events ' | ||
- | </ | ||
- | |||
- | |||
- | |||
- | |||
- | \\ | ||
- | Disable tracing: | ||
- | <code sql> | ||
- | alter system set events ' | ||
- | alter system set events ' | ||
- | </ | ||
dba/oracle/howtos/howto_trace_sql.txt · Last modified: 2023/01/31 08:26 by dodger