/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.
| | dioncho.wordpress.com
Interesting case of the restriction of global hints | Dion Cho - Oracle Performance Storyteller
1.3 parsecs away

Travel
| | One of my colleagues sent following test case, of which he couldn't control the join order with hints. 1. Create objects - table t1, t2 and t3 2. Now Let's set the join order as T1->T2->T3, using global hints convention. But it seems that Oracle does not work as expected. It really seems that the...
| | 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...
| | dincosman.com
Direct Path Read Decision in Oracle: Beyond the Optimizer - Osman's DBlog
7.4 parsecs away

Travel
| The performance issue with an SQL query was resolved by using the /*+ PARALLEL(2) */ hint, reducing execution time from 180-200 seconds to milliseconds. The decision to perform a direct read from disk to memory instead of reading blocks from disk was made by the database engine and is controlled by the hidden "_serial_direct_read" parameter....