Summary

• Lots of performance and tuning enhancements

  • V$SQL_PLAN and V$SQL_PLAN_STATISTICS
  • DBMS_STATS instead of ANALYZE
  • Dynamic Sampling
  • Bind variable peeking
  • Cursor Sharing Improvements
  • Index Monitoring
  • Table Compression
  • Parallel DML on non-partitioned tables
  • FIRST_ROWS_n Optimization

• Will we get better performance and the ability to support more data and more users?

Notes: