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		oracleprof.blogspot.com Oracle Performance and Backup Blog: How to find SQL_ID and PLAN_HASH_VALUE in Oracle SQL Plan Management Baselines
\|	\|	orastory.wordpress.com SQL_IDs and baselines \| OraStory	0.9 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)....	0.9 parsecs away Travel
\|	\|	kerryosborne.oracle-guy.com Kerry Osborne's Oracle Blog » Blog Archive » How to Attach a SQL Profile to a Different Statement	1.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.	1.1 parsecs away Travel
\|	\|	hourim.wordpress.com How to attach a hinted SPM baseline to a non hinted sql query? \| Mohamed Houri's Oracle Notes	1.4 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...	1.4 parsecs away Travel
\|	\|	www.bobbydurrettdba.com Cardinality errors across joins \| Bobby Durrett's DBA Blog	13.6 parsecs away Travel
\|		We have been discussing query tuning at work and I've come back to an example of the Oracle optimizer choosing the wrong plan due to an error in its calculation of the number of rows returned...	13.6 parsecs away Travel