Tag Archives: 11gr2

Integration of Editions with Services in 11.2.0.2…

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…




Segment Creation on Demand (Deferred Segment Creation) in Oracle 11.2.0.2…

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…




Oracle 11gR2 on Oracle Linux 6…

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…

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 [...]




APPEND_VALUES Hint…

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…




Fedora 13 and Oracle…

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…




Oracle RAC on VirtualBox…

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 [...]




Data Guard Setup using Oracle Grid Control

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…




Oracle Database File System (DBFS) PL/SQL APIs…

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…




Oracle Database File System (DBFS) in 11gR2…

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 [...]