Explore >> Select a destination
|
You are here 
|
blog.sqlora.com | ||
| | | | |
jonathanlewis.wordpress.com
|
|
| | | | | Conclusion When using the merge command to process small amounts of data be careful that you don't manage to enable parallel DML or you may find that you add a lot of empty space to the object. This could become very wasteful if you were running a loop that processed a few rows on every... | |
| | | | |
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. | |
| | | | |
nenadnoveljic.com
|
|
| | | | | A boundary condition where subpartition statistics gathering can also trigger partition statistics | |
| | | | |
oracletoday.blogspot.com
|
|
| | | I use STATSPACK extensively for comparing two time periods, comparing a time period to a baseline, monitoring trends and diagnosing perform... | ||
