Who's online

There are currently 0 users and 46 guests online.

Recent comments



Partitioned Clusters

In case you hadn’t noticed it, partitioning has finally reached clusters in 12c – specifically They’re limited to hash clusters with range partitioning, but it may be enough to encourage more people to use the technology. Here’s a simple example of the syntax:

The Future of PL/SQL : My Opinion

Although a lot of my effort at the moment is focused on DBA features, I have written some articles on PL/SQL enhancements. There are a few neat new features for PL/SQL developers in 12c, but you could be forgiven for thinking it is a little underwhelming. There are two ways to look at this:

  1. OMG. Oracle really don’t care about PL/SQL any more. If they did, there would be loads of new features.
  2. Wow. PL/SQL is so mature and cool that there is really not much more to add.

From a base language perspective, I think option 2 is closer to the mark. PL/SQL is a really stable, fast and mature language. There really isn’t very much that you can’t do with PL/SQL these days. So what is the future of PL/SQL in my opinion?

How to Configure EM12c to NOT Use Load Balancers

This may not come up very often, but for some reason, an administrator might have to reconfigure an EM12c environment to NOT use load balancers.

This could be due to:

New Oracle CEOs “Hurd ‘n’ Catz”: This should be great

“Hurd’n’Catz” – I’ve always liked Larry, and especially in the old unscripted public discussions of technology. The best one I was at was at the Fairmont in 1994, but I’m biased because I was the MC. Larry and Ron Wohl were on hand for a general question and answer session instead of having a keynote talk at a particularly robust OAUG conference. After a few questions from the audience it turned into a snappy debate between Ron and Larry about how the future of some pretty doggone important things to the entire audience were going to go. I barely had to egg them on. It was real and it was useful. I think Larry was genuinely disappointed we had to stop when it was time for the vendor sponsored cocktail reception. I wish Larry well and I would not begrudge him for a second letting go of pain in the butt day to day control.

#OakTable World at Oracle OpenWorld 2014

WhereChildren’s Creativity Museum, 221 4th St, San Francisco

When:  Mon-Tue, 29-30 September, 08:30 – 17:00 PDT

Back to technology: Is it effective to place Oracle REDO on SSD?

Ever since I was asked to improve the throughput of an actual general ledger posting job involving Oracle in December 1993 on some hardware where solid state disk (SSD) was available (at high cost relative to “spinning rust” or hard disk drives [HDD]), I have been trying to explain the overall advantage of placing different types of the different Oracle storage selectively on SSD.

When FLASH SSD arrived on the scene, studies quickly arose that writing to FLASH SSD is often not as fast as writing to disk drives dedicated to receiving those writes.

Today I’ll try to explain why I don’t care.

While there was some advantage to writing to SSD in my tests (which were to RAM based SSD on a VAX), the write speed to online REDO was not a significant part of the advantage of placing online REDO on SSD.

Shrink Tablespace

A recent question on the OTN database forum raised the topic of returning free space in a tablespace to the operating system by rebuilding objects to fill the gaps near the start of files and leave the empty space at the ends of files so that the files could be resized downwards.

This isn’t a process that you’re likely to need frequently, but I have written a couple of notes about it, including a sample query to produce a map of the free and used space in a tablespace. While reading the thread, though, it crossed my mind that recent versions of Oracle introduced a feature that can reduce the amount of work needed to get the job done, so I thought I’d demonstrate the point here.

Private Cloud and Lifecycle Management with EM12c at OOW14

Yet again the monster that is Oracle Open World is about to take over San Francisco. I won’t be making it this year, but considering we had something like 60,000 attendees last year I’d hate to see what the numbers are gonna be this year! :)

To try and make it a little easier for you to find all the Private Cloud and Lifecycle Management with EM12c material, here are the ones I know about. If you know of any I’ve missed, feel free to add them in the comments field below! Note that this is only the Private Cloud and Lifecycle Management material – the complete master list of all EM material can be found in the master Focus On EM12c document.

#CloneAttack at Oracle OpenWorld 2014

Delphix and Dbvisit will be at the OTN Lounge in the lobby of Moscone South from 3:30 – 5:00pm on Monday 29-Sept.  Come join us to hear about #CloneAttack and #RepAttack, two great hands-on learning opportunities.


Oracle Midlands Event #6 : Registration Open

Registration for Oracle Midlands Event #6 is now open. Here’s the information from the website.


I’ve registered. See you there!