Outer Web | Explore

Explore >> Select a destination

You are here		www.pythian.com DML Part of a Parallel INSERT Suddenly Started to Execute Serially in Oracle
\|	\|	dincosman.com Direct Path Read Decision in Oracle: Beyond the Optimizer - Osman's DBlog	1.1 parsecs away Travel
\|	\|	The performance issue with an SQL query was resolved by using the /+ PARALLEL(2) / hint, reducing execution time from 180-200 seconds to milliseconds. The decision to perform a direct read from disk to memory instead of reading blocks from disk was made by the database engine and is controlled by the hidden "_serial_direct_read" parameter....	1.1 parsecs away Travel
\|	\|	www.dbaglobe.com Donghua's Blog - DBAGlobe: "HASH JOIN FULL OUTER" in explain plan (11g onwards)	2.2 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.	2.2 parsecs away Travel
\|	\|	tonyhasler.wordpress.com Parallel partition scans \| Tony's Oracle Tips	1.8 parsecs away Travel
\|	\|	When a table is accessed by multiple members of a parallel query server set, the execution plan may show the use of block range granules (PX BLOCK ITERATOR) or partition granules (PX PARTITION [RANGE\|LIST\|HASH] ITERATOR or PX PARTITION [RANGE\|LIST\|HASH] ALL). The basic ideas surrounding these concepts are discussed in numerous blogs and books, including my...	1.8 parsecs away Travel
\|	\|	kerryosborne.oracle-guy.com Kerry Osborne's Oracle Blog » Blog Archive » How to Attach a SQL Profile to a Different Statement	15.4 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.	15.4 parsecs away Travel