Outer Web | Explore

Explore >> Select a destination

You are here		nenadnoveljic.com ORA-07445 [__intel_avx_rep_memcpy()] During a Rowset Operation - All-round Database Topics
\|	\|	www.dbaglobe.com Donghua's Blog - DBAGlobe: How the Query Optimizer Chooses Execution Plans for Joins	11.5 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.	11.5 parsecs away Travel
\|	\|	hourim.wordpress.com How to attach a hinted SPM baseline to a non hinted sql query? \| Mohamed Houri's Oracle Notes	13.2 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...	13.2 parsecs away Travel
\|	\|	jonathanlewis.wordpress.com dbms_xplan in 10g \| Oracle Scratchpad	10.5 parsecs away Travel
\|	\|	[More on dbms_xplan.display_cursor()] If you're using 9i and haven't learned about the dbms_xplan package, then you should take a good look atit right away. It's(usually) a much better wayof getting execution plans from your system thanwriting yourown queries against the plan_table. If you'vebeen using dbms_xplan, and upgraded from 9i to 10g, make sure that you...	10.5 parsecs away Travel
\|	\|	dban00b.wordpress.com Latch free waits, Dynamic Statistics, and the Result Cache - DBA n00b	69.2 parsecs away Travel
\|		2016-11-29 EDIT: Oracle has announced that in 12.2 the features that drove this overuse of the result cache (dynamic stats triggered by SPDs) will default to off, and provided patches to apply to 12.1 as well. More info here. Also, some investigation by Mauro Pagano around the impact of the new OPTIMIZER_ADAPTIVE_STATISTICS parameter turned up...	69.2 parsecs away Travel