/explore

Click through on any links that interest you or select the planets on the right to continue exploring the Outer Web.
You are here

kerryosborne.oracle-guy.com
| | tonyhasler.wordpress.com
2.3 parsecs away

Travel
| | Note that there is a follow up to this post here that you should read after this post. Stored outlines were introduced in Oracle 9i as a way of helping stabilise execution plans. In 11gR1 these are deprecated in favour of enterprise-edition-only SQL Baselines (sorry standard edition users )-:) but as of 11gR2 neither facility...
| | hourim.wordpress.com
2.7 parsecs away

Travel
| | The last Jonathan Lewis post on RAC Planswhich finished by the following phrases: "If you're going to hard-code hints into a query then take a look at the outline it generates when it does the right thing, and that will tell you about the 15 or so hints you've missed out. (Better still, consider generating...
| | oracle-randolf.blogspot.com
1.9 parsecs away

Travel
| | On the OTN forum very often tuning requests about single SQL statements are posted, but the information provided is rather limited, and ther...
| | blog.yannickjaquier.com
15.5 parsecs away

Travel
| Automatic SQL Tuning Sets (ASTS) can be of great help to auto repair SQL queries that have diverged from their ideal execution plan