Just released an article on Table Compression Enhancements in 11g.
Cheers
Tim…
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 [...]
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 [...]
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 [...]
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 [...]
¶
Posted 19 February 2008
† Tim...
§
Oracle
‡
°
Also tagged: adaptive cursor sharing, ddl_lock_timeout, enhancements, fine grained dependency management, invisible indexes, new features, ocp, online table redefinition, Oracle, query result cache, temporary tablespace
Here’s a little something about Automatic SQL Tuning in Oracle 11g. No DBAs necessary in 11g…
Cheers
Tim…
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 [...]
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 [...]
My Fedora 8 escapades were delayed by my OpenWorld experience, but better late than never.
Fedora 8 (F8) Installation
Oracle 11g On Fedora 8 (F8)
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 [...]
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 [...]