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		hourim.wordpress.com How to attach a hinted SPM baseline to a non hinted sql query? \| Mohamed Houri's Oracle Notes
\|	\|	orastory.wordpress.com SQL_IDs and baselines \| OraStory 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.3 parsecs Travel
\|	\|
\|	\|	tonyhasler.wordpress.com FORCE_MATCH for Stored Outlines and/or SQL Baselines? - follow up \| Tony's Oracle Tips 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.3 parsecs Travel
\|	\|
\|	\|	oracleprof.blogspot.com Oracle Performance and Backup Blog: How to find SQL_ID and PLAN_HASH_VALUE in Oracle SQL Plan Management Baselines SQL_ID and/or PLAN_HASH_VALUE are used almost globally across Oracle database to identify query. This is not a case for SPM mechanism using...	1.3 parsecs Travel
\|	\|
\|	\|	www.xt-r.com XT&R blackboard: ? distinct values ?, ? TopN	5.4 parsecs Travel
\|