Effective Use of Oracle SQL Trace
Extended SQL Trace is one of the most effective diagnostic tools for Oracle. When done properly, tracing reveals exactly what calls a user session is making and eliminates guess work when addressing performance issues. This presentation focuses on real life experience with lightly documented issues and covers how to properly trace a user session, wait events, trace file architecture and how to read it, and summarizing session activity using profiling tools. We finish with several test cases demonstrating the usefulness of sql trace to diagnose session, sql, system and architecture issues.
Presenter: Daniel Fink specializes in Oracle performance diagnosis and optimization, monitoring and data recovery. He has been in IT for over 17 years, first as a Cobol programmer on the Vax VMS platform. In 1995, he transitioned to Oracle, first as a developer, then DBA...on DEC Alpha OpenVMS and Oracle Parallel Server 7.0.13. He has been both a development and production DBA (often at the same time). For the past 5 years, Daniel has focused on Oracle performance diagnosis and optimization. He has been a member of the Oak Table Network (www.oaktable.net) since 2004. Daniel has presented at conferences and user group meetings across the United States and Europe, including RMOUG Training Days, The Hotsos Symposium, IOUG-A Live!, UKOUG, Miracle dbForums in Denmark and Scotland.