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		tanelpoder.com Manual "before" and "after" snapshot support in Snapper v4 \| Tanel Poder Blog
\|	\|	blog.tanelpoder.com Optimizer statistics-driven direct path read decision for full table scans (_direct_read_decision_statistics_driven) \| Tanel Poder Blog	1.0 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.	1.0 parsecs away Travel
\|	\|	www.dbaglobe.com Donghua's Blog - DBAGlobe: Subquery Performance Tuning (Part 2, NOT IN and NOT EXISTS))	3.6 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.	3.6 parsecs away Travel
\|	\|	oracleprof.blogspot.com Oracle Performance and Backup Blog: How to find SQL_ID and PLAN_HASH_VALUE in Oracle SQL Plan Management Baselines	4.0 parsecs away Travel
\|	\|	SQL_ID and/or PLAN_HASH_VALUE are used almost globally across Oracle database to identify query. This is not a case for SPM mechanism using...	4.0 parsecs away Travel
\|	\|	afatkulin.blogspot.com Alex Fatkulin's Blog: Update and rownum oddity	13.7 parsecs away Travel
\|		Take a look at the following table: SQL> create table codes 2 ( 3 code varchar2(10), 4 used number, 5 constraint pk_cod...	13.7 parsecs away Travel