/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

 dioncho.wordpress.com
Interesting case of the restriction of global hints | Dion Cho - Oracle Performance Storyteller
| | www.dbaglobe.com
Donghua's Blog - DBAGlobe: Subquery Performance Tuning (Part 2, NOT IN and NOT EXISTS))
1.1 parsecs away

Travel
| | A blog about on new technologie. Hands-on note about Hadoop, Cloudera, Hortonworks, NoSQL, Cassandra, Neo4j, MongoDB, Oracle, SQL Server, Linux, etc.
| | tonyhasler.wordpress.com
FORCE_MATCH for Stored Outlines and/or SQL Baselines? | Tony's Oracle Tips
1.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...
| | leonotes.wordpress.com
(transitive closure)?(Constraint-Generated Predicates) | LEO Notes
1.4 parsecs away

Travel
| | transitive closure?Wiki?Oracle?...
| | jonathanlewis.wordpress.com
SQL Profiles - 2 | Oracle Scratchpad
12.9 parsecs away

Travel
| Following yesterday's note on SQL Profiles, someone asked how I detect that an opt_estimate hint had been used - with specific reference to the "index_scan" option. The reason for this particular choice is that other opt_estimate hints have a highly visible impact in the 10053 trace files, but this one doesn't. Here are a few...