NYOUG SIG Meeting
120 Park Avenue
New York, NY 10017
USA
NYOUG SIG Meeting
Agenda
PRESENTER: Arup Nanda
TOPIC: “The Art and Craft of Tracing and Profiling”
Tracing activities are an important part of the tuning process. This presentation explains how to enable various types of tracing including extended (aka 10046); how to trace in case of connection pools before the sessions are established, how to pull specific sessions from the mass of traces, how to trace in RAC, how to consolidate masses of traces to make a meaningful analysis and how to read and interpret the seemingly arcane trace files. While tracing is useful for singular query sessions, it’s useless in PL/SQL routines where a few lines of code may generate thousands of lines of query. Profiling helps in this case by exposing the portion that takes the most time. This presentation will describe the profiling techniques in PL/SQL, and 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 of the tips and techniques will be shown with live examples.
6:00 – 6:50 PM – Part 1
6:50 – 7:10 PM – Pizza and refreshments
7:10 – 8:00 PM – Part 2
RSVP:
You must be a paid current member of NYOUG to attend this meeting at no charge. Non-members may pay $10 at the door (cash or check only).
Complete and submit this form.