/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

 oracle-randolf.blogspot.com
Oracle related stuff: Oracle 23c FREE - Unrestricted Direct Path Loads glitches
| | afatkulin.blogspot.com
Alex Fatkulin's Blog: 11G adaptive direct path reads - what is the cached/dirty blocks threshold?
3.4 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 ...
| | blog.sqlora.com
Online Statistics Gathering: Update 2024
2.2 parsecs away

Travel
| | Here is an overview of some improvements to Online Statistics Gathering in Oracle Releases 19c-23ai
| | tonyhasler.wordpress.com
Parallel partition scans | Tony's Oracle Tips
4.0 parsecs away

Travel
| | When a table is accessed by multiple members of a parallel query server set, the execution plan may show the use of block range granules (PX BLOCK ITERATOR) or partition granules (PX PARTITION [RANGE|LIST|HASH] ITERATOR or PX PARTITION [RANGE|LIST|HASH] ALL). The basic ideas surrounding these concepts are discussed in numerous blogs and books, including my...
| | dincosman.com
Direct Path Read Decision in Oracle: Beyond the Optimizer - Osman's DBlog
6.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....