Outer Web | Explore

Explore >> Select a destination

You are here		iusoltsev.wordpress.com ??????? ??????: FIRST_ROWS ? CURSOR_SHARING_EXACT \| Oracle mechanics
\|	\|	orastory.wordpress.com SQL_IDs and baselines \| OraStory	7.7 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)....	7.7 parsecs away Travel
\|	\|	kerryosborne.oracle-guy.com Kerry Osborne's Oracle Blog » Blog Archive » Explain Plan Lies	6.0 parsecs away Travel
\|	\|		6.0 parsecs away Travel
\|	\|	oracle-randolf.blogspot.com Oracle related stuff: Getting first rows of a large sorted result set quickly - NOSORT issues	5.7 parsecs away Travel
\|	\|	When attempting to display only the first n rows of a result set that is ordered the Oracle optimizer offers special optimizations for these...	5.7 parsecs away Travel
\|	\|	alexzeng.wordpress.com Outline, SQL profile and SQL Plan Management(SPM) \| Alex Zeng's Blog	63.3 parsecs away Travel
\|		Outline is the oldest way to fix SQL plan. It based on hints like use_nl etc. It's a road map. It still can be used in 11.2 although oracle said it's deprecated. Finally, it is free. SQL profile is trying to impact CBO by adding cost estimation hints. You need pay extra money to use...	63.3 parsecs away Travel