partitioning – Page 3 – Learning is not a spectator sport

Partitioning Guide updated

Just a quick note to say I’ve updated our Getting Started With Partitioning Guide! 9 easy to follow demonstrations to

One of the cool features in 12c is the automatic collection of optimizer statistics when a table is either created

Interval partitioning was a great feature when it arrived in version 11, because we no longer had to worry so

When dealing with a RANGE partitioned table, the defined partitions dictate all of the data that can be placed into

Let’s say I’ve got a partitioned table, and because New Year’s eve is coming around, I certainly don’t want to

We’re being asked to store more and more data, yet keep backup windows, query performance and the like unchanged, no

In my previous post we saw that the partition number in the execution plan might not align with the partition

This issue came through from an AskTom question, that turned out to be a known bug. In my talks on

Things get a little interesting in the data dictionary when it comes to interval partitions. Consider the following example: SQL>

I had a question on AskTom recently, where due to concurrency issues, the poster of the question wanted to take