/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

 www.bobbydurrettdba.com
Parsing blocks stats blocks parsing | Bobby Durrett's DBA Blog
| | mwidlake.wordpress.com
03 | July | 2009 | Martin Widlake's Yet Another Oracle Blog
3.6 parsecs away

Travel
| | 1 post published by mwidlake on July 3, 2009
| | mauro-pagano.com
Dynamic Sampling just got better | Mauro Pagano's Blog
4.1 parsecs away

Travel
| | 12c brought several new features in the SQL performance area and the most advertised one is probablyAdaptive Query Optimization. The Adaptive Plans feature has been described in a lot of details (specially the adaptive join methods part) and most of the focus in Adaptive Statistics has been on SQL Plan Directives and Automatic Re-optimization, not...
| | 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.
| | nenadnoveljic.com
Performance Problem with Incremental Statistics Calculation - All-round Database Topics
26.4 parsecs away

Travel
| A frequently executed SQL causes problems with the initial incremental statistics calculation.