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.|
|Date:||Tuesday, April 15, 2008|
|Time:||9:45 AM - 10:45 AM|