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		afatkulin.blogspot.com Alex Fatkulin's Blog: v$result_cache_memory or what is the newest method to hang stuff up?
\|	\|	blog.tanelpoder.com Optimizer statistics-driven direct path read decision for full table scans (_direct_read_decision_statistics_driven) \| Tanel Poder Blog	3.4 parsecs away Travel
\|	\|	Hello all fellow Oracle geeks and technology enthusiasts! Long time no see ;-) In the hacking session about Oracle full table scans and direct path reads I explained how the direct path read decision is not done by the optimizer, but instead during every execution, separately for every single segment (partition) scanned in the query. I also explained how the _small_table_thresholdparameter and theX$KCBOQH.NUM_BUF(which keeps track of how many buffers of any segment are currently cached) are used for determining whether to scan using direct path reads or not. - Linux, Oracle, SQL performance tuning and troubleshooting training & writing.	3.4 parsecs away Travel
\|	\|	oracletoday.blogspot.com Oracle Today: Performance of Autotrace	1.2 parsecs away Travel
\|	\|	I have been having some performance problems when using autotrace in some production systems. I finally had time to check out why. I enabled...	1.2 parsecs away Travel
\|	\|	oracle-randolf.blogspot.com Oracle related stuff: Getting first rows of a large sorted result set quickly - NOSORT issues	3.5 parsecs away Travel
\|	\|	When attempting to display only the first n rows of a result set that is ordered the Oracle optimizer offers special optimizations for these...	3.5 parsecs away Travel
\|	\|	kerryosborne.oracle-guy.com Kerry Osborne's Oracle Blog » Blog Archive » Explain Plan Lies	14.2 parsecs away Travel
\|			14.2 parsecs away Travel