What’s New for Tuning?

• Precise Query Statistics and Plans

  • V$SQL_PLAN and V$SQL_PLAN_STATISTICS

• ANALYZE is formally deprecated

  • Use DBMS_STATS

• Dynamic Sampling

• New Cursor sharing features

• Table Compression

• Parallel DML on non-partitioned tables

• More...

• Let’s take a look at each in turn...

Notes: