/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

 antognini.ch
Partition-Wise Operations - New Features in 12c and 18c - Striving for Optimal Performance
| | dincosman.com
Direct Path Read Decision in Oracle: Beyond the Optimizer - Osman's DBlog
1.9 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....