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
\|	\|	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
\|	\|	optimizermagic.blogspot.com Inside the Oracle Optimizer - Removing the black magic: Displaying and reading the execution plans for a SQL statement	1.3 parsecs away Travel
\|	\|	Generating and displaying the execution plan of a SQL statement is a common task for most DBAs, SQL developers, and preformance experts as i...	1.3 parsecs away Travel
\|	\|	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
\|	\|	oracle-randolf.blogspot.com Oracle related stuff: New Parallel Distribution Method For Direct Path Loads	10.1 parsecs away Travel
\|		Starting with version 12c Oracle obviously has introduced another parallel distribution method for direct path loads (applicable to INSERT A...	10.1 parsecs away Travel