356: Oracle 10g/11g DBMS_XPLAN
Carol Dacko , Independent    Biography

Objectives: Learn various methods of displaying information including access paths and predicate information.
Learn how to extract information from AWR tables to use for troubleshooting purposes.
Learn different format options depending upon the amount of detail needed.
Abstract: This presentation will demonstrate that the basic understanding of this Oracle supplied packages is instrumental to the success of the developer and DBA. DBMS_XPLAN is a utility that easily formats the contents of the explain plan. There are a variety of enhancements that assist the developer and DBA alike in determining how Oracle decided to execute a particular query. Some of the extensions that will be investigated are column projections, runtime statistics and reviewing plans for historic cursors.

Audiernce Focus: DBA
Expertise: Intermediate
Track: Database
Date: Wednesday, April 16, 2008
Time: 11:00 AM - 12:00 PM