/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

 alexzeng.wordpress.com
Outline, SQL profile and SQL Plan Management(SPM) | Alex Zeng's Blog
| | tonyhasler.wordpress.com
FORCE_MATCH for Stored Outlines and/or SQL Baselines? - follow up | Tony's Oracle Tips
1.5 parsecs away

Travel
| | As has happened a couple of times recently, comments on a blog of mine have helped me understand the subject matter on which I am commenting far better. In this case a dialogue with Dom Brooks on my previous blog on how to simulate a stored outline/SQL baseline with FORCE_MATCH using SQL profiles has provided...
| | www.bobbydurrettdba.com
Using coe_xfr_sql_profile.sql to force a good plan | Bobby Durrett's DBA Blog
2.5 parsecs away

Travel
| | Sunday night we worked with Oracle Support on a performance issue with a query that had been running for over 14 hours even though it ran the previous weekend in five minutes. Oracle Support showe...
| | jonathanlewis.wordpress.com
SQL Profiles - 2 | Oracle Scratchpad
2.2 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...
| | savvinov.com
DBMS_XPLAN.DISPLAY_CURSOR - Oracle Diagnostician
20.8 parsecs away

Travel
| In this post, I continue on the topic of examining SQL plans. I will talk about one DBMS_XPLAN function, DISPLAY_CURSOR (because it's probably the most useful one when troubleshooting ongoing performance issues, and also because other functions have a lot of similiarity to it). I will discuss frequently used options and some common problems. Preparation...