423: Do You Know the Plan?
Mahesh Vallampati , Hotsos    Biography

Objectives: Understand Plan Table evolution from 9i to 10g
Understand V$SQL_PLAN and supporting tables
Use DBMS_XPLAN and use it effectively on a daily basis for SQL Tuning
Abstract: This presentation describes the evolution of the Plan Table, V$SQL_PLAN and DBMS_XPLAN from 9i to 11g and how they can aid in effective and efficient SQL Tuning. DBMS_XPLAN speficically has much to offer to the DBA and the Developer and has evolved from 1 function in 9i to 6 in 10g and 14 in 11g and will be demonstrated in detail.

Audiernce Focus: Developers
Expertise: Beginner
Track: Development
Date: Tuesday, April 15, 2008
Time: 9:45 AM - 10:45 AM