There’s a neat new feature for editioning in 11.2.0.2 that allows you to associate an edition with a service. I’ve added it to the end of my Edition-Based Redefinition article here. Cheers Tim…
It looks like 11.2.0.2 has improved most of the original shortfalls of segment creation on demand that were present in 11.2.0.1. Segment Creation on Demand (Deferred Segment Creation) in Oracle Database 11g Release 2 Cheers Tim…
With the arrival of Oracle Linux 6 comes the inevitable installation articles. Oracle Linux 6 Installation Oracle Database 11g Release 2 (11.2) Installation On Oracle Linux 6 The Oracle installation on Oracle Linux 6 is certainly smoother than the recent Fedora installations have been. Even Enterprise Manager works fine with no meddling. The official 11gR2 [...]
Fedora 14 is here and so are the obligatory articles: Fedora 14 (F14) Installation Oracle Database 11g Release 2 (11.2) Installation On Fedora 14 (F14) My attitude to Fedora and Ubuntu as changed today, with most of that shift due to VirtualBox. Before I switched to VirtualBox I was always reliant on my OS being [...]
The APPEND_VALUES hint is new to 11gR2 and allows you to use direct-path inserts from “INSERT INTO … VALUES” type statements. Pretty neat if you are doing inserts in a FORALL statement and need the extra punch. Cheers Tim…
Until a couple of days ago I hadn’t even realized that Fedora 13 was out. I guess that shows how interested I am in Fedora these days. Anyway, I had a play around with it. Fedora 13 (F13) Installation Oracle Database 11g Release 2 (11.2) Installation On Fedora 13 (F13) Cheers Tim…
With the recent news that the latest version of VirtualBox now supports shared disks, I thought I better give it a go and see if I could do a RAC installation on it. The good news is it worked as expected. You can see a quick run through here: Oracle Database 11g Release 2 RAC [...]
Just a point-and-click guide to Data Guard setup using Grid Control. Oracle Database 11g Release 2 Data Guard Setup using Oracle Grid Control Cheers Tim…
My previous article discussed the DBFS. This article gives an overview of the PL/SQL APIs for managing and interacting with the DBFS. Oracle Database File System (DBFS) PL/SQL APIs There’s a lot in there, so this is just skimming the surface. Cheers Tim…
I’ve been having a play with the DBFS functionality in 11gR2. Oracle Database File System (DBFS) in Oracle Database 11g Release 2 For the most part it is extremely simple. If you are working on Linux then it’s a really neat solution. On any other platform you are limited to using the dbfs_client tool, which [...]