Got a question for the Optimizer team?

If you have an idea for a post you would like to see on our blog please email us


Thursday, November 29, 2007

Welcome to our blog

This blog will be our groups opportunity to set the record straight on the Oracle Cost Based Optimizer, and the statistics that feed it. It will also give you the opportunity to post questions and have them answered by the team.

8 comments:

jan van mourik said...

Wonderful! Thanks for doing this, I'm sure it will be very useful! Looking forward to your blog entries!

Aman.... said...

hi there,
I really liked the post.Going to add it my blogroll,site.Hope I shall learn alot about my optimizer.
Keep the good posts coming.
Cheers,
Aman....

Anonymous said...

Excellent job guys, looking forward for more posts
Malak Aziz

dbajack said...

I'm having trouble with a production query that is exhibiting strange behavior. The first time or 2 that it is parsed following an instance start, it chooses a bad plan. Shortly thereafter it will start choosing a different (better) plan. What factors could cause this behavior? The stats have not changed, nor have the system stats. I have 10053 traces for both the good and bad plans. Is this an ok forum to ask such a question? I've had an SR open for more than 2 months with no valuable suggestions to show for it.

Unknown said...

Thank you very much for this wonderful blog...Hope 2 become better developers...

Mayimbe said...

This is what we need it. In an age where MISinformation can cause a lot confusion/frustrations. It's refreshing, to get information right from the source.

Mayimbe said...

This is what we need it. In an age where MISinformation can cause a lot confusion/frustrations. It's refreshing, to get information right from the source.

Unknown said...

sounds like a good blog