All About Query Performance Tuning and Application Performance Tuning Using TKPROF
This thread is for discussion and questions about using SQL Trace/10046 trace and formatting the output using TKPROF to diagnose applications performance problems.
General Advice:
- For any session and/or transaction running slow whether via application, batch job or just a script running in SQL*Plus, 10046 trace(SQL_TRACE) must be generated with proper level(usually 8 or 12). To explore all possible ways to generate such traces, refer to:
- Once the run time trace(s)(10046) is generated, it can be formatted using TKPROF utility. To explore how to run TKPROF, refer to:
0