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 |