Outer Web | Explore

Explore >> Select a destination

You are here		antognini.ch Impact of Direct Reads on Delayed Block Cleanouts - Striving for Optimal Performance
\|	\|	hoopercharles.wordpress.com True or False - Undo \| Charles Hooper's Oracle Notes	8.3 parsecs away Travel
\|	\|	May 9, 2010 (Back to the Previous Post in the Series)(Forward to theNext Post in the Series) Continuing the true or false blog article series with more questions that seem to have conflicting answers,if the answers to those questions depend on the source of the informationfound through Internet searches. Today's quiz is on the topic...	8.3 parsecs away Travel
\|	\|	dincosman.com Direct Path Read Decision in Oracle: Beyond the Optimizer - Osman's DBlog	11.0 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....	11.0 parsecs away Travel
\|	\|	sqlmaria.com Online Statistics Gathering	13.1 parsecs away Travel
\|	\|	Although there have been a number of significant changes to the Oracle Database in 12c, some of my favorite new features are actually the small enhancements, designed to make your life a little eas...	13.1 parsecs away Travel
\|	\|	tonyhasler.wordpress.com Parallel partition scans \| Tony's Oracle Tips	60.5 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...	60.5 parsecs away Travel