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 [...]
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 [...]
More OCP revision notes. This time an overview of ASM enhancements… Automatic Storage Manager (ASM) Enhancements in Oracle Database 11g Release 1 Cheers Tim…
I’ve just put another Oracle 11g new features article live: Resource Manager Enhancements in Oracle Database 11g Release 1 Cheers Tim…
The latest article in my OCP revision notes has surfaced: Scheduler Enhancements in Oracle Database 11g Release 1 The detached and lightweight jobs look fine, but I’m not totally happy with the remote external jobs. I don’t think they quite live up to their promise, and they seem like a security issue waiting to happen. [...]
I’m sorry to polute my movie review blog with some Oracle stuff, but here’s a little something on AWR Baseline Enhancements in 11g. Cheers Tim…
Some more OCP upgrade exam revision notes: Automated Database Maintenance Task Management in Oracle Database 11g Release 1 I’ve tried to avoid getting caught up in a discussion of the scheduler and resource manager as this would make the article massive. Cheers Tim…
The latest addition to my OCP upgrade exam revision notes is now live: Statistics Collection Enhancements in Oracle Database 11g Release 1 Cheers Tim…
I’m still trying to work my way through the 11g new features for the OCP upgrade exam. I’ve had so much going on recently that I’m still only about 2/3 of the way through the syllabus. Here’s the latest installment. Automatic Memory Management in Oracle Database 11g Release 1 I guess I need to write [...]