Explore >> Select a destination

You are here

 blog.tanelpoder.com
Optimizer statistics-driven direct path read decision for full table scans (_direct_read_decision_statistics_driven) | Tanel Poder Blog
| | dincosman.com
Direct Path Read Decision in Oracle: Beyond the Optimizer - Osman's DBlog
0.6 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
2.6 parsecs away

Travel
| |
| | afatkulin.blogspot.com
Alex Fatkulin's Blog: 11G adaptive direct path reads -- what is the cached/dirty blocks threshold?
1.3 parsecs away

Travel
| | 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 ...
| | kerryosborne.oracle-guy.com
Kerry Osborne's Oracle Blog » Blog Archive » How to Attach a SQL Profile to a Different Statement
14.2 parsecs away

Travel
| [AI summary] The article discusses techniques for using SQL Profiles to influence query optimization in Oracle databases, building on previous methods like outline switching.