Explore >> Select a destination

You are here

 afatkulin.blogspot.com
Alex Fatkulin's Blog: 11G adaptive direct path reads -- what is the cached/dirty blocks threshold?
| | 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.2 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....
| | oracle-randolf.blogspot.com
Oracle related stuff: Getting first rows of a large sorted result set quickly - NOSORT issues
4.6 parsecs away

Travel
| | When attempting to display only the first n rows of a result set that is ordered the Oracle optimizer offers special optimizations for these...
| | antognini.ch
V$SQL_CS_HISTOGRAMS: What Are the Buckets' Thresholds? - Striving for Optimal Performance
9.4 parsecs away

Travel
|