CHAPTER 6Using EXPLAIN and STORED OUTLINES (Developer and DBA)
Finding and fixing problem queries has a lot to do with using the tools that are available. Different tools need to be used for different situations. The tools covered in this chapter are Oracle's provided utilities: SQL TRACE, TKPROF, EXPLAIN PLAN, and STORED OUTLINES (also known as PLAN STABILITY). With Oracle 10g, these tools have been enhanced, including the addition of the DBMS_MONITOR package and TRCSESS. The SQL tracing options have been centralized and extended using the DBMS_MONITOR package. TRCSESS is a command-line tool that allows developers and DBAs to consolidate the information from more than one trace file into a single output file.
The topics covered in this chapter ...
Get Oracle Database 10g Performance Tuning Tips & Techniques now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
