/explore
|
You are here 
|
nenadnoveljic.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. |
|
| | | | | ||
| | | | |
savvinov.com
Introduction In my earlier post, I described a method of troubleshooting slow queries using dbms_xplan. While this method is all you need in most cases, it does have one serious problem: it requires the problem query be completed before any diagnostics are taken. What if the query is so slow that it cannot finish within... |
|
| | | | | ||
| | | | |
blog.toadworld.com
Why my execution plan has not been shared - Part II Oracle |
|
| | | | | ||
| | | | |
www.xt-r.com
|
|
| | | |||
