Carlos Sierra's Tools and Tips

Tools and Tips for Oracle Performance and SQL Tuning

Posts Tagged ‘Test Case

SQL Tuning Workshop I (updated schedule of sessions)

leave a comment »

I opened 3 sessions of the internal SQL Tuning Workshop I.

  • June 11-14, Orlando, FL
  • July 9-13, Toronto, Canada
  • July 30-August 3, Colorado Springs, CO

This intermediate to advanced class includes these topics:

  • Explaining the Explain Plan
  • Statistics Foundations
  • CBO Fundamentals I
  • Statistics Best Practices
  • CBO Fundamentals II
  • Extended Statistics
  • Dynamic Sampling
  • Event 10053 Tracing the CBO
  • Event 10046 Tracing the Execution
  • SQLT Foundations
  • SQLT Intermediate
  • Real-life Case Studies

I still have some seats available for Orlando and Colorado Springs. For registration please follow instructions on internal link.

Written by Carlos Sierra

May 29, 2012 at 2:43 pm

How to create in 5 minutes a SQL Tuning Test Case using SQLTXPLAIN

leave a comment »

I presented this topic at the 2012 Hotsos Symposium on March. Today, I am delivering a Webinar at 11 AM ET on the same. If you want to attend please register at webex.

Recording of this Webinar will be available at MOS 740964.1. Look under Oracle-Database link.

Written by Carlos Sierra

April 26, 2012 at 9:29 am


Tagged with , ,