Outer Web | Explore

Explore >> Select a destination

You are here		jonathanlewis.wordpress.com Why Undo ? \| Oracle Scratchpad
\|	\|	hoopercharles.wordpress.com True or False - Undo \| Charles Hooper's Oracle Notes	3.0 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...	3.0 parsecs away Travel
\|	\|	dincosman.com Direct Path Read Decision in Oracle: Beyond the Optimizer - Osman's DBlog	4.8 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....	4.8 parsecs away Travel
\|	\|	blog.developpez.com A quoi sert l'undo (rollback segment), par Jonathan Lewis \| Oracle - Concepts et Exemples	1.6 parsecs away Travel
\|	\|		1.6 parsecs away Travel
\|	\|	jonathanlewis.wordpress.com SQL Profiles - 2 \| Oracle Scratchpad	42.5 parsecs away Travel
\|		Following yesterday's note on SQL Profiles, someone asked how I detect that an opt_estimate hint had been used - with specific reference to the "index_scan" option. The reason for this particular choice is that other opt_estimate hints have a highly visible impact in the 10053 trace files, but this one doesn't. Here are a few...	42.5 parsecs away Travel