SecureFiles in Oracle 11g…

I’ve just posted an article on SecureFiles in Oracle 11g. It looks like Oracle have done a pretty good job of improving LOBs in 11g. Depending on the LOB contents, and provided you can cope with the processing overhead, you can certainly save some serious space using the compression and deduplication options. Anyone who’s used Transparent Data Encryption (TDE) will recognize the encryption options.

I can’t see the old-style (BasicFile) LOBs lasting very long now this is in place. 🙂

Cheers

Tim…

Tablespace Encryption in 11g…

I spent yesterday looking at the Tablespace Encryption feature in Oracle 11g. If you’ve used the Transparent Data Encryption (TDE) feature in 10g release 2, you’ll see this is more of the same. The difference here is eveything in the tablespace is encrypted, rather than having to decide on a column-by-column basis. Just create the appropriate tablespace and Bob’s your uncle!

You may notice the article conveniently side-steps the Hardware Security Modules related functionality. I don’t have one so I can’t test it out. 🙂

For most of the stuff I work on, encrypting all the columns in a table is overkill, but I guess there are some areas where this is a big priority. It’s good to know it’s there in case you ever need it. 🙂

Cheers

Tim…

Fine-Grained Access to Network Services in 11g…

Continuing my OCP 11g upgrade campaign, I’ve been looking at Fine-Grained Access to Network Services in Oracle Database 11g Release 1.

This represents a pretty major security improvement for Oracle 11g. In previous versions the all-or-nothing security associated with database callouts was a little ham-fisted to say the least.

On the down side, I think it will confuse a few people when they are upgrading existing databases, but it’s a small price to pay for the peace of mind.

Cheers

Tim…

11g bits and bobs…

I’ve just released an article covering the Miscellaneous New Features section of the OCP upgrade exam. It contains a rather random assortment of stuff including:

  • Online Table Redefinition Enhancements
  • Enhanced Finer Grained Dependency Management
  • DDL With the WAIT Option (DDL_LOCK_TIMEOUT)
  • Invisible Indexes
  • Query Result Cache
  • Adaptive Cursor Sharing
  • Temporary Tablespace Enhancements

I was toying with the idea of putting each section out as separate articles, but they’re all pretty small soundbites, so I thought I would be better to stick with grouping in the OCP syllabus.

Cheers

Tim…

RMAN Enhancements in 11g…

My trip through the 11g new features continues with RMAN Ehancements. These combined with the Data Recovery Advisor and Flashback and LogMiner Enhancements I wrote about previously show that Oracle are really putting a lot of effort into getting this area right. I guess the Data Recovery Advisor will be the most outstanding new feature for most people, but there are loads of tweaks all round that all help to make life easier for us guys on the coal face.

Cheers

Tim…

Data Recovery Advisor…

When I first saw the name Data Recovery Advisor, I thought I was going to have a really dull time figuring how this new 11g functionality worked, but it is really quite cool!

I don’t care if you are a beginner or a battle-scarred DBA, every time you have to recovery a database, you get a little twinge of doubt about whether it’s going to work. Sure, if your backups are good and you’ve practiced your recovery scenarios it should work, but what if…

The Data Recovery Advisor goes some way towards calming those jitters by automatically identifying, diagnosing and optionally repairing the problem for you. I think this is totally cool and a great move by Oracle.

Cheers

Tim…

PS. This article got on the front page before it was actually finished. I apologize if you caught the half-done version. 🙂

Fedora 8 and Oracle 11g…

My Fedora 8 escapades were delayed by my OpenWorld experience, but better late than never.

The first article is a run through of a fairly basic Fedora 8 install, showing what it looks like. The second is the Oracle install guide in my normal format. There’s one little nasty in there, but for the most part it was pretty smooth sailing, especially since a guy called “Robert W. Benton” emailed me to tell me what the problem was before I had even finished downloading the OS. Thanks for that Robert. 🙂

I’ve mentioned this before, and I’ll no doubt mention it again, but I’m really struggling to see what the Fedora distribution is aiming for. It seems to send out contradicting messages at times. For instance, it has features that make me think it is a desktop OS:

  • Looks very soft and cuddly like a desktop OS.
  • It pops up an annoying warning message if I log on as root.
  • Users get sub-directories like Documents, Downloads, Music, Videos created by default.

But for me the big contradictions are:

  • The distribution is really big. I would expect a desktop OS to come on one CD, with the extra features available for download.
  • The installation process seems rather clumsy compared to Ubuntu. It’s not a big difference, but that slight bit of extra complexity makes it feel like a server installation to me. Don’t get me wrong, it’s not hard, but I’ve been doing this since Red Hat 5.2, so I’m not exactly a Linux newbie. I feel it could be simplified further.

Looking from the other angle, it could be considered a server OS, after all it is a playground for Red Hat (a bit of flame-bait there 🙂 ), but some of the previously mentioned points detract from that message. I remember all those people telling me that Windows wasn’t a real server OS because it forced you to have gizmos like Media Player etc. Fedora has this same feel to me now. Plus the DVD is missing a number of packages that I would expect an enterprise distribution to have. I know they are available for download, but as a server OS I would prefer to forgo the fluffy guff in favor of the enterprise stuff.

I can image some of the responses to this post. No doubt some Fedora fan[boys|girls] will post telling me that Fedora is a great desktop and/or server OS… blah, blah, blah… I’m not doubting that. I just think that we have to recognize that the server and the desktop are two totally different experiences and I don’t think Fedora sells itself well enough on either front.

Ubuntu is a classic example of how to do it right. I don’t believe it is significantly better than Fedora, but it had a clear message from day one. We all knew it was a desktop OS and it acted like that. They’ve subsequently gone the server route also, but they’ve kept it as a separate entity. This is no different to the way Microsoft tackled the same issue.

I really feel like Fedora must decide what its purpose is, or it’s just going to end up another one of those faceless distributions you try, think of as OK, then ditch in favor of something else that suits your purpose better…

Cheers

Tim…

11g Downloads?

It looks like the new 11g downloads have been taken off OTN. The plot thickens… See here.

Update: They’re back again this morning!

I was reading the list of new downloads off the page to Laurent Schneider and Lutz Hartmann and the page looked fine. About 1 hour later I was talking to Andrew Clarke and I went to page and it had reverted to the previous options. I refreshed the page and everything. Andrew is my witness… 🙂

I guess it doesn’t matter now…