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		kerryosborne.oracle-guy.com Kerry Osborne's Oracle Blog » Blog Archive » Explain Plan Lies
\|	\|	iusoltsev.wordpress.com FIRST_ROWS CURSOR_SHARING_EXACT \| Oracle mechanics	1.3 parsecs away Travel
\|	\|	465 ?! SELECT A.ID, A.LOGIN, A.NAME, A.LASTNAME, A.EMAIL FROM ACCOUNT A WHERE (A.LOGIN LIKE '%%') AND (A.NAME LIKE '%?%' OR A.LASTNAME LIKE '%?%') AND A.COMPANY_ID = 1 ORDER BY A.LOGIN ?, ? ? A.COMPANY_ID = 1 ? SQL> SELECT 'ALL' as "Condition", count(*) FROM ACCOUNT...	1.3 parsecs away Travel
\|	\|	orastory.wordpress.com SQL_IDs and baselines \| OraStory	1.4 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.4 parsecs away Travel
\|	\|	www.dbaglobe.com Donghua's Blog - DBAGlobe: "HASH JOIN FULL OUTER" in explain plan (11g onwards)	1.4 parsecs away Travel
\|	\|	A blog about on new technologie. Hands-on note about Hadoop, Cloudera, Hortonworks, NoSQL, Cassandra, Neo4j, MongoDB, Oracle, SQL Server, Linux, etc.	1.4 parsecs away Travel
\|	\|	www.xt-r.com XT&R blackboard: ? distinct values ?, ? TopN	10.7 parsecs away Travel
\|			10.7 parsecs away Travel