/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
Kerry Osborne's Oracle Blog » Blog Archive » Do SQL Plan Baselines Use Hints?
| | jonathanlewis.wordpress.com
SQL Profiles - 2 | Oracle Scratchpad
1.8 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...
| | hourim.wordpress.com
How to attach a hinted SPM baseline to a non hinted sql query? | Mohamed Houri's Oracle Notes
1.9 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...
| | leonotes.wordpress.com
(transitive closure)?(Constraint-Generated Predicates) | LEO Notes
2.1 parsecs away

Travel
| | transitive closure?Wiki?Oracle?...
| | chandlerdba.com
SQL Patch, and a Parallel mistake - Neil Chandler's DB Blog
19.1 parsecs away

Travel
| Photo by Brian Patrick Tagalog on Unsplash July 2024. Oracle 19c, 23ai There are 3 main types of SQL Plan Management: SQL Profile SQL Plan Baseline SQL Patch So first some quick background info about the 3 options and then I'll tell you about my mistake. SQL Profile A SQL Profile is a collections of...