Wordpress - richardfoote.wordpress.com - Richard Foote's Oracle Blog
General Information:
Latest News:
12c Asynchronous Global Index Maintenance Part III (Re-Make/Re-Model) 7 Aug 2013 | 02:56 pm
As I discussed previously in Part I, the space occupied by orphaned row entries associated with asynchronously maintained global indexes is not automatically reclaimed by subsequent DML operations wit...
12c Asynchronous Global Index Maintenance Part II (The Space Between) 6 Aug 2013 | 03:28 pm
In Part I, I discussed how global indexes can now be asynchronously maintained in Oracle 12c when a table partition is dropped or truncated. Basically, when a table partition is dropped/truncated with...
12c Asynchronous Global Index Maintenance Part I (Where Are We Now ?) 2 Aug 2013 | 03:02 pm
I previously looked at how global index maintenance was performed when dropping a table partition prior to Oracle Database 12c. Let’s see how things have now changed since the introduction of 12c. Let...
Reuse Of Empty Index Leaf Blocks (Free Four) 1 Aug 2013 | 12:50 pm
A recent question by Stalin Subbiah has prompted me to write a quick post on the reuse of empty leaf blocks. In part, the question asked: “Is there anyway I could monitor the effectiveness of empty bl...
Global Index Maintenance – Pre 12c (Unwashed and Somewhat Slightly Dazed) 26 Jul 2013 | 11:33 am
Before I discuss another Oracle Database 12c new feature, Asynchronous Global Index Maintenance, thought it might be worthwhile discussing how Global Indexes were handled prior to 12c. I’ll begin by c...
Upcoming Oracle Events in Canberra (The Show Must Go On) 19 Jul 2013 | 08:55 am
For those of you who live locally in the Canberra region, there are a couple of key Oracle events coming up. Oracle Database 12c Launch Date: Friday, July 26 2013 Time: 8:30 AM – 1:00 PM Where: Hyatt ...
12c Partial Indexes For Partitioned Tables Part II (Vanishing Act) 12 Jul 2013 | 11:46 am
In Partial Indexes Part I, we looked at how it was possible with the 12c database to create a Partial Index based on data from only selected table partitions. The resultant Partial Index can be eithe...
12c Partial Indexes For Partitioned Tables Part I (Ignoreland) 8 Jul 2013 | 12:13 pm
In my opinion, one of the unsung “Heroes” of the new 12c Oracle database are improvements associated with Partitioning. There are lots of really nice capabilities introduced in the 12c database that s...
12c: Intro To Multiple Indexes On Same Column List (Repetition) 2 Jul 2013 | 11:14 am
From an indexing perspective, one of the bigger ticket items introduced with Oracle Database 12c is the new capability to create multiple indexes on the same column list. It’s even a feature listed in...
Oracle Database 12c Released – Lots of Indexing Stuff To Talk About 26 Jun 2013 | 05:24 am
Finally, Oracle have released the long awaited 12c Database. You can now download it from OTN and other usual places. This is good news as my tongue was getting rather sore from having to bite on it f...
