/explore

Click through on any links that interest you or select the planets on the right to continue exploring the Outer Web.
You are here

 afatkulin.blogspot.com
Alex Fatkulin's Blog: 11G adaptive direct path reads - what is the cached/dirty blocks threshold?
| | blog.tanelpoder.com
Optimizer statistics-driven direct path read decision for full table scans (_direct_read_decision_statistics_driven) | Tanel Poder Blog
1.3 parsecs away

Travel
| | 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.
| | antognini.ch
Impact of Direct Reads on Delayed Block Cleanouts - Striving for Optimal Performance
2.4 parsecs away

Travel
| |
| | dincosman.com
Direct Path Read Decision in Oracle: Beyond the Optimizer - Osman's DBlog
3.1 parsecs away

Travel
| | The performance issue with an SQL query was resolved by using the /*+ PARALLEL(2) */ hint, reducing execution time from 180-200 seconds to milliseconds. The decision to perform a direct read from disk to memory instead of reading blocks from disk was made by the database engine and is controlled by the hidden "_serial_direct_read" parameter....
| | rwijk.blogspot.com
About Oracle: dbms_xplan.display_cursor
15.7 parsecs away

Travel
|