Tag Archives: database

Oracle Database SQL Expert (1Z0-047)…

I can see this post degenerating into a rant, so I would like to preemptively appologize to anyone involved in the production of this exam. I’m guessing it’s a real pain to develop these exams, especially when some ass like me starts moaning about them. Added to that, I’m guessing the word “Expert” means slightly [...]

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

Oracle 11gR2 RAC On Linux Using NFS

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…

Dipping my toe in 11gR2…

I’ve had my first play with 11gR2 today: Oracle Database 11g Release 2 (11.2) Installation On Enterprise Linux 5.0 Nothing too unpredictable really. I guess the most noticeable change is the new installer. I didn’t have an issue with the old installer, but a few friends from the Microsoft world had pointed out how dated [...]

Resource Manager Enhancements in 11g…

I’ve just put another Oracle 11g new features article live: Resource Manager Enhancements in Oracle Database 11g Release 1 Cheers Tim…

Database Change Notification…

I’ve recently been playing around with Database Change Notification, which is basically an asynchronous triggering mechanism. I’m not really sure why I would use it in an application, but it’s always nice to know about this stuff, just in case. I suppose it’s not drastically dissimilar to the the use of a handler module in [...]