/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

 blog.sqlora.com
Online Statistics Gathering: Update 2024
| | oracle-randolf.blogspot.com
Oracle related stuff: Oracle 23c FREE - Unrestricted Direct Path Loads glitches
2.2 parsecs away

Travel
| | Playing around with some new features added in 23c - here the removal of the restriction so far that Direct Path loads or Parallel DML preve...
| | oracle-base.com
Bigfile Tablespace Shrink in Oracle Database 23ai/26ai - ORACLE-BASE
2.5 parsecs away

Travel
| | Bigfile Tablespace Shrink in Oracle Database 23ai/26ai - ORACLE-BASE
| | nenadnoveljic.com
Undocumented Implicit Partition Statistics Gathering - All-round Database Topics
2.7 parsecs away

Travel
| | A boundary condition where subpartition statistics gathering can also trigger partition statistics
| | jonathanlewis.wordpress.com
Bind Peeking | Oracle Scratchpad
19.4 parsecs away

Travel
| Here's a simple detail about bind peeking (during optimisation) that makes a big difference to "fetch first/next" queries. The optimizer knows about your bind types, and can peek at the bind values - but that doesn't mean it will do something sensible with them. Here's a little model to demonstrate the problem - starting with...