/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

 tonyhasler.wordpress.com
FORCE_MATCH for Stored Outlines and/or SQL Baselines? | Tony's Oracle Tips
| | kerryosborne.oracle-guy.com
Kerry Osborne's Oracle Blog » Blog Archive » Do SQL Plan Baselines Use Hints?
1.7 parsecs away

Travel
| | [AI summary] A technical investigation into whether Oracle SQL Plan Baselines store actual execution plans or rely on hidden hints, analyzing database trace files and data dictionary views.
| | hourim.wordpress.com
How to attach a hinted SPM baseline to a non hinted sql query? | Mohamed Houri's Oracle Notes
2.5 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...
| | alexzeng.wordpress.com
Outline, SQL profile and SQL Plan Management(SPM) | Alex Zeng's Blog
2.6 parsecs away

Travel
| | Outline is the oldest way to fix SQL plan. It based on hints like use_nl etc. It's a road map. It still can be used in 11.2 although oracle said it's deprecated. Finally, it is free. SQL profile is trying to impact CBO by adding cost estimation hints. You need pay extra money to use...
| | oracleprof.blogspot.com
Oracle Performance and Backup Blog: How to find SQL_ID and PLAN_HASH_VALUE in Oracle SQL Plan Management Baselines
14.2 parsecs away

Travel
| SQL_ID and/or PLAN_HASH_VALUE are used almost globally across Oracle database to identify query. This is not a case for SPM mechanism using...