Richard Foote's Blog

Subscribe to Richard Foote's Blog feed Richard Foote's Blog
Focusing Specifically On Oracle Indexes, Database Administration and Some Great Music
Updated: 4 days 22 hours ago

12.2 Some Cool Partitioning New Features (Big Wheels)

Wed, 04/05/2017 - 08:21
I previously discussed just how easy it is to convert online a non-partitioned table to be partitioned with Oracle Database 12.2. Thought I might run through a number of really cool new partitioning features and capabilities that were also introduced in 12.2. To start, I’m just going to create a basic range-partitioning table and populate […]

Big Announcement – New Job, New Country (A New Career In A New Town)

Fri, 03/31/2017 - 13:45
APRIL FOOLS After 5 1/2 years at Oracle Corporation, I’ve decided to leave and take on a very exciting new challenge !! President Trump’s office have accepted my nomination to head their IT department in Washington DC, where I’ll be responsible for ensuring all USA government data is stored in a extremely efficient and secure manner. So […]

12.2 Online Conversion of a Non-Partitioned Table to a Partitioned Table (A Small Plot Of Land)

Sun, 03/26/2017 - 23:46
In my previous post, I discussed how you can now move heap tables online with Oracle Database 12.2 and how this can be very beneficial in helping to address issues with the Clustering Factor of key indexes. A problem with this technique is that is requires the entire table to be effectively reorganised when most of […]

Let’s Talk Database: New Dates Released (You Can’t Talk)

Thu, 03/16/2017 - 05:53
Good news for all you Oracle Database folk in ANZ. I’ll be running a new series of “Let’s Talk Database” sessions at a venue near you in the coming months. I’ll be discussing two interesting topics, “Introduction to the Oracle Cloud for DBAs” and “Introduction to Oracle Database 12c Release 2“. The dates for this series and registration […]

12.2 Moving Tables Online (Real Cool World)

Wed, 03/15/2017 - 06:41
One of the really cool new features introduced in Oracle Database 12c Release 2 is the capability to MOVE tables ONLINE, while maintaining all the associated index structures. This was possible for table partitions in Oracle Database 12c Release 1 but only for Indexed Organized Tables before then. Rather than show a demo that just moves a table, […]

12.2 Index Advanced Compression “High” Part IV (The Width of a Circle)

Fri, 03/10/2017 - 05:18
A quick post (for me) with a long weekend beckoning… In Part I, Part II and Part III of looking at the new Index Advanced Compression level of “High”, we discussed how it can significantly decrease the size of your indexes in a manner not previously possible. This can result in significant reductions of index storage and […]

Hotsos Symposium 2017: Feb 27 – Mar 2 Dallas, Texas (I’m Afraid of Americans)

Mon, 02/06/2017 - 06:42
In just 3 weeks time, I’ll again have the pleasure of presenting at the awesome Hotsos Symposium in Dallas, Texas. It’s simply the best conference with regard to Oracle performance tuning anywhere. This year, I’ll be presenting on a couple of topics: New Index Features Introduced in Oracle Database 12c Release 2 Oracle Database 12c […]