Carlos Sierra's Tools and Tips

Tools and Tips for Oracle Performance and SQL Tuning

Archive for the ‘General’ Category

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

Welcome to my blog on Oracle SQL Tuning!

with one comment

It has been a while since I first thought on starting a blog on Oracle SQL Tuning. Over the past decade or so I have accumulated a lot of practical knowledge in this interesting area. Even when I keep sharing this knowledge with my fellow co-workers at Oracle, I always feel like I should expand my horizon to the larger community who is out there, dealing the same kind of issues that I do, re-discovering the hard way many things that we already know.

After an enlightening moment while participating as a speaker at the awesome Hotsos Symposium 2012, I decided to open up and reach out. I have been learning from others through their valuable blogs. Now it is time to pay back, and share with whoever is interested in Oracle SQL Tuning, whatever I have learned over the years.

Nothing that I post is Oracle confidential. I blog about what I have learned through others, and through carefully crafted models that demonstrate how things actually work. I also blog about the tools that I have created over the years, and which I have made available to the Oracle community through My Oracle Support (MOS).

This place is a a friendly place. If you come here, I hope it is because you want to learn something new, or you want to share something you know. I will make mistakes, and I expect you to let me know if what I write seems to be wrong. I do my best to minimize the number of mistakes that I make, but I am far from perfect.

With all that said, I truly welcome you to this place.

Written by Carlos Sierra

April 1, 2012 at 12:58 pm

Posted in General