June 24, 2014
The Art and Craft of Tracing - Arup Nanda
Tracing sessions is an important part of the tuning process. This month, Oracle Ace Director Arup Nanda will join us to discuss how to enable various types of tracing including extended (aka 10046); how to enable tracefiles in case of connection pools before the sessions are established, how to pull specific sessions from the mass of traces, how to enable tracing in case of RAC, how to consolidate masses of traces to make a meaningful analysis and much more. You will learn:
(1) how to enable traces in sessions that are not even established yet
(2) how to consolidate multiple tracefiles into a single one, especially in RAC and connection pool environments
(3) how to enable tracing in running sessions - regular and extended
A. What is trace
B. How to trace a running session
C. How to enable waits and binds in the trace
- Using events
- Using dbms_monitor
D. How to enable traces in a future session
E. Consolidating several traces
F. Filtering for specific trace information
Time permitting, Arup will also discuss Tuning PL/SQL via Profiling. You will learn the profiling techniques in PL/SQL, how to use the PL/SQL profiler to identify the elapsed time in each call, or sub-call. Both the traditional and hierarchical profilers will be explained. All the tips and techniques will be shown with live examples.
Arup Nanda has been working as an Oracle DBA for last 20 years touching all aspects of the database from modeling to performance tuning to security and disaster recovery. He has presented 300 sessions, written 500 articles, co-authored 5 books and delivered trainings in 22 countries. He is an Oracle ACE Director, a member of Oak Table Network, a member of Board of Directors of Exadata SIG and an editor for SELECT journal. He was the recipient of two Oracle's most prestigious awards: DBA of the Year in 2003 and Architect of the Year in 2012.
For information on usual meeting locations and times as well as previous
meeting minutes and presentations please refer to the
For further information or enquiries regarding meetings please
contact the SOUG meeting coordinator.