/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

 tonyhasler.wordpress.com
The importance of the GLOBAL_STATS statistic on partitioned tables | Tony's Oracle Tips
| | 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
| | mauro-pagano.com
SQL Diag Repository | Mauro Pagano's Blog
2.9 parsecs away

Travel
| | Every once in a while I look around the list of new (fixed) views in the instance trying to find useful / interesting things to add to SQLd360 and recently I stumbled into V$SQL_DIAG_REPOSITORY / V$SQL_DIAG_REPOSTIORY_REASON. SQL> desc v$sql_diag_repository Name Null? Type - - - ADDRESS RAW(8) CON_ID NUMBER HASH_VALUE NUMBER SQL_ID VARCHAR2(13) CHILD_NUMBER NUMBER...
| | antognini.ch
Partition-Wise Operations - New Features in 12c and 18c - Striving for Optimal Performance
3.0 parsecs away

Travel
| | [AI summary] This article details new SQL features in Oracle 12c and 18c that enhance partition-wise operations for GROUP BY, DISTINCT, and windowing functions to improve parallel query performance.
| | blog.yannickjaquier.com
Automatic SQL Tuning Sets (ASTS) hidden feature hands-on
17.4 parsecs away

Travel
| Automatic SQL Tuning Sets (ASTS) can be of great help to auto repair SQL queries that have diverged from their ideal execution plan