Posts by Grégory Guillou

Tuning Pack 11g : Real-Time SQL Monitoring

“Real Time SQL Monitoring” is a 11g Tuning Pack new feature. You can easily access it when the Tuning Pack is set. Anyway, It’s very impressive even if it doesn’t look to be fully functional (Is it me ?). I guess Enterprise Manager provides a fantastic GUI for this feature. This post is for you if you don’t always use it…

Oracle 11g : I miss the price !

I rushed into my favorite book, Oracle Database Licensing Information – 11g Release 1. Guess what? We now have 4 new opportunities to do business with Oracle. I still miss the price list. As if you could look at a new Release without the price ;)

The good and the bad about bind variables, re-revisited in 11g !

It would not have been fair to show how Oracle 11g optimizer can now re-parse a query based on the execution statistics associated with a bind value compared to the previous executions of the same query with different bind values. It would not have been fair, to show you that without showing what happens when the second execution is faster that the first one, even with a sub optimal plan. This is what I’ll do now !

Basically, what is done in the example below it the opposite of what I’ve done in my previous post.

When 11g SQL is faster than 10g without any plan change…

To avoid being too far behind you guys that are already upgrading to 11g, I’ve decided to invest on 11g during the Beta Program. This has been a lot of fun and I wish I can share some of my findings with you. For example, did you know that 11g can go faster without any change at all ? The queries here will illustrate the change made to the Nested Loop Algorithm in 11g :

Page 4 of 41234