Outer Web | Explore

/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...	1.5 parsecs away Travel
\|	\|	orastory.wordpress.com SQL_IDs and baselines \| OraStory	1.8 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)....	1.8 parsecs away Travel
\|	\|	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...	2.5 parsecs away Travel
\|	\|	jakeseliger.com 2012 October 09 « The Story's Story	17.5 parsecs away Travel
\|		1 post published by Jake Seliger on October 9, 2012	17.5 parsecs away Travel