Explore >> Select a destination

You are here

 tonyhasler.wordpress.com
The importance of the GLOBAL_STATS statistic on partitioned tables | Tony's Oracle Tips
| | antognini.ch
Partition-Wise Operations - New Features in 12c and 18c - Striving for Optimal Performance
3.0 parsecs away

Travel
| |
| | 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
Re-partitioning 2 | Oracle Scratchpad
4.1 parsecs away

Travel
| | Last week I wrote a note about turning a range-partitioned table into a range/list composite partitioned table using features included in 12.2 of Oracle. But my example was really just an outline of the method and bypassed a number of the little extra problems you're likely to see in a real-world system, so in this...
| | tonyhasler.wordpress.com
FORCE_MATCH for Stored Outlines and/or SQL Baselines????? | Tony's Oracle Tips
31.6 parsecs away

Travel
| Note that there is a follow up to this post here that you should read after this post. Stored outlines were introduced in Oracle 9i as a way of helping stabilise execution plans. In 11gR1 these are deprecated in favour of enterprise-edition-only SQL Baselines (sorry standard edition users )-:) but as of 11gR2 neither facility...