Explore >> Select a destination


You are here

chandlerdba.com
| | tonyhasler.wordpress.com
9.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...
| | kerryosborne.oracle-guy.com
4.9 parsecs away

Travel
| |
| | jonathanlewis.wordpress.com
0.1 parsecs away

Travel
| | Here's a quick and dirty script I thought I'd published a very long time ago. It has to be run as SYS and queries v$sql_hint to produce a list of all the things which (at least in theory) could be used as hints somewhere in the code. I've ordered the list by the columns version...
| | kerryosborne.oracle-guy.com
43.0 parsecs away

Travel
| [AI summary] The article discusses techniques for using SQL Profiles to influence query optimization in Oracle databases, building on previous methods like outline switching.