Explore >> Select a destination
|
You are here 
|
antognini.ch | ||
| | | | |
jonathanlewis.wordpress.com
|
|
| | | | | There is some confusion about the expression "clean" in Oracle circles, so I thought I'd write a short note to explain the different ways in which the word may be applied to Oracle blocks. There are five terms to consider: clean commit cleanout block cleanout delayed block cleanout delayed logging block cleanout Clean: A block... | |
| | | | |
afatkulin.blogspot.com
|
|
| | | | | 11G's ability to do direct path reads during full table scans without utilizing PQ was covered in a number of places already (see this post ... | |
| | | | |
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. | |
| | | | |
jonathanlewis.wordpress.com
|
|
| | | Following yesterday's note on SQL Profiles, someone asked how I detect that an opt_estimate hint had been used - with specific reference to the "index_scan" option. The reason for this particular choice is that other opt_estimate hints have a highly visible impact in the 10053 trace files, but this one doesn't. Here are a few... | ||
