Outer Web | Explore

Explore >> Select a destination

You are here		tonyhasler.wordpress.com FORCE_MATCH for Stored Outlines and/or SQL Baselines????? - follow up \| Tony's Oracle Tips
\|	\|	jonathanlewis.wordpress.com SQL Profiles - 2 \| Oracle Scratchpad	1.6 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...	1.6 parsecs away Travel
\|	\|	kerryosborne.oracle-guy.com Kerry Osborne's Oracle Blog » Blog Archive » How to Attach a SQL Profile to a Different Statement	2.1 parsecs away Travel
\|	\|	[AI summary] The article discusses techniques for using SQL Profiles to influence query optimization in Oracle databases, building on previous methods like outline switching.	2.1 parsecs away Travel
\|	\|	orastory.wordpress.com SQL_IDs and baselines \| OraStory	2.4 parsecs away Travel
\|	\|	There have been some interesting posts from Marcin Przepiorowski and Kerry Osborne about mapping sql plan management (spm) baselines to a corresponding sql id. The key to sql plan baselines (DBA_SQL_PLAN_BASELINES) is SIGNATURE. And why signature? It's not just another change to the key to identifying sql statements (HASH_VALUE -> (NEW_)HASH_VALUE / OLD_HASH_VALUE -> SQL_ID)....	2.4 parsecs away Travel
\|	\|	www.bobbydurrettdba.com Using coe_xfr_sql_profile.sql to force a good plan \| Bobby Durrett's DBA Blog	13.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...	13.5 parsecs away Travel