/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

 sqlmaria.com
Online Statistics Gathering
| | blog.sqlora.com
Online Statistics Gathering: Update 2024
0.7 parsecs away

Travel
| | Here is an overview of some improvements to Online Statistics Gathering in Oracle Releases 19c-23ai
| | oracle-base.com
Bigfile Tablespace Shrink in Oracle Database 23ai/26ai - ORACLE-BASE
2.2 parsecs away

Travel
| | Bigfile Tablespace Shrink in Oracle Database 23ai/26ai - ORACLE-BASE
| | oracle-randolf.blogspot.com
Oracle related stuff: Getting first rows of a large sorted result set quickly - NOSORT issues
2.5 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...
| | dincosman.com
Direct Path Read Decision in Oracle: Beyond the Optimizer - Osman's DBlog
6.0 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....