12c Release 2 – Transparent Data Encryption online !

It doesn’t take a rocket scientist to know that even if you have incredibly stringent controls on user authentication, user authorisation etc, that wont save you if your data on disk is not encrypted.  All you need is an errant tape, a missing disk, a misplaced flash stick…and kersplat, someone has a copy of your datafiles from your Oracle database.

Data at rest should be encrypted, but that often meant taking applications offline to do so.

I’ve put my Speed Racer hat on Smile and here’s a video on a new 12c Release 2 feature covered in 60 seconds !

AskTom TV

Sometimes at conferences I get asked – “How do you know all of the answers for the AskTom questions?”

I’d love to say “Because we’re super smart” Smile but the reality is, we’re just like anyone else with a passion for database technology.  We like to research things, apply our skills and use our experience to solve problems.

So I’ve realised that even though we try to give as much detail as possible when we are helping the AskTom community, it might not always be immediately apparent what thought process we followed when tackling a problem.

To help with that, we now have “AskTom TV”.   It’s not really a TV show Smile but what we’re doing is taking a sample AskTom question, and talking about how we tackled a problem, rather than just jumping straight to the solution.

The first two episodes are here, and there will be more to come throughout 2017.


UKOUG 2016

Just a little video montage of the fun and learning from UKOUG.  A great conference every year.

I was fortunate enough to receive a Best Speaker award (from a 12c features talk given at the 2015 conference). I gave three talks, one of which was the Database Keynote for 2016 – I felt very privileged for the invitation to do so.  The slides for the talks can be found on the AskTom site under the Resources tab.

But for me, there were two highlights – one professional and one personal.

  • The professional one was the same as per most conferences – the ability to catch up face to face with IT professionals from both inside Oracle Corporation and the greater Oracle community.  Whilst we all “blog”, and “tweet”, and “discuss” in some way shape or form, you can’t still beat banter over a beer Smile I love it when casual conversation often leads to insights into technical areas that you hadn’t really even planned on chatting about.
  • The personal one was a little surprise my partner Genevieve sprung on me.  Secretly she had booked flight tickets to align with mine, and hence there she was at the airport at 3am ready to jump on board the flight with me to the UK.  It was an awesome early Christmas gift !

If I don’t get a chance to blog again in the next 48 hours, have a great New Year’s eve celebration wherever you are in the world.

A cool thing with EXCHANGE PARTITION (part 2)

In the previous post, I showed that even though a partition was “removed” (ie, exchanged out) from a table, a query running against the table could still successfully run the completion.

However, of course, if once that partition is exchanged out, it is now a table in it’s own right…and is subject to the whims of what a DBA may wish to do with it.   If that table is dropped, or truncated, then as you might expect, our query is going to struggle to find that data ! Smile

Here’s an example of what happens when the query cannot successfully run: