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 finally got round to trying an NFS installation of 11gR2 RAC.
Oracle Database 11g Release 2 RAC On Linux Using NFS
No real surprises here. It all seems a little simpler when using NFS, but it was cronically slow on my crappy kit.
Cheers
Tim…
I’ve taken my first tentative steps into 11gR2 RAC and it was a big surprise.
Oracle 11g Release 2 RAC On Linux Using VMware Server 2
11gR2 RAC feels very different to 11gR1 RAC. I can imagine quite a few people wanting to upgrade from 11gR1 thinking it will be trivial and getting a rude awakening…
The Grid [...]
I’ve been running through my demos before my PL/SQL workshop in Utrecht and I noticed a change in the behaviour of the PL/SQL Function Result Cache. In 11gR1 it was necessary to specify dependencies using the RELIES ON clause, but now Oracle 11gR2 takes care of Detection of Sources for you. Neat.
Cheers
Tim…
It’s that time again where I check to see if Oracle installs on the latest version of Fedora. The result once again is yes, it does. The main website has the links to the articles. I would add links here only the browser on this internet cafe machine doesn’t support cut & pates.
When [...]
Here’s the first addition to the website in 2009:
Data Pump Enhancements in Oracle Database 11g Release 1
One hand typing takes a long time.
Cheers
Tim…
I like to meddle with Fedora from time to time, just so I can see what’s coming round the corner in RHEL. I read recently that Fedora 11 will be the base for RHEL6, which means we are about 6 months away from seeing what the future of RHEL is going to be…
Much as I [...]
I’m trying to get back into the swing of writing again after my 2 month layoff. It’s a little daunting, but quite fun as well.
There’s a bunch of 11g new features that didn’t make it into the OCP exam, and the PIVOT and UNPIVOT operators fall slap bang into that category.
PIVOT and UNPIVOT Operators in [...]
I mentioned in a previous post I had taken the plunge and upgraded to VMware Server 2 on my laptop. Now I’ve also upgraded my main machine at home and it seems to be working fine. Probably the most complicated thing I run at home is a virtual RAC, so I wrote a new article [...]
I passed the Oracle Database 11g: New Features for Administrators (1Z0-050) exam today. It’s a bit of a relief because I feel like I’ve been preparing for this exam for a year. My first OCP revision article was written about 1 year ago, when I was hoping to be ready for the beta exam. Unfortunately, all the [...]