Explore >> Select a destination
|
You are here 
|
www.bobbydurrettdba.com | ||
| | | | |
blog.tanelpoder.com
|
|
| | | | | 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. | |
| | | | |
mwidlake.wordpress.com
|
|
| | | | | 1 post published by mwidlake on July 3, 2009 | |
| | | | |
mahmoudhatem.wordpress.com
|
|
| | | | | Since oracle 12.2.0.1 Adaptive Dynamic Sampling result are stored inside SPD as a special directive type "DYNAMIC_SAMPLING_RESULT". This will allow the result of ADS to be persisted on disk,thus it will survive memory flush and database restart.For more detailed info please check Mauro Pagano blog Post Something new about SQL Plan Directives and 12.2 We... | |
| | | | |
oracletoday.blogspot.com
|
|
| | | I have been having some performance problems when using autotrace in some production systems. I finally had time to check out why. I enabled... | ||
