Explore >> Select a destination
|
You are here 
|
afatkulin.blogspot.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. | |
| | | | |
oracleprof.blogspot.com
|
|
| | | | | 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... | |
| | | | |
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... | |
| | | | |
jhdba.wordpress.com
|
|
| | | STOP PRESS - 17 Nov 2009 - updated with latest code which works against both 10g and 11g databases I am attaching scripts which I wrote a while ago to automatically pick any sql_ids reported in the latest ADDMand then run sql_advisor toreport on any tuning advice. I am not suggesting that the information they... | ||
