A client of mine is performing a conversion process that takes days to run and of course it would be […]
In defence of being lazy
So today I wanted to export a 35GB partitioned table and really didn’t feel like going through the process of […]
In praise of Oracle Support
Many of us don’t think too much about Oracle Support services – they are there and they sit on a […]
Incremental backup sizing using the Crystal Ball method.
A quick read of Oracle’s support site (support.oracle.com for those with an account) can sometimes reveal a gem or two. […]
SQL*Plus login script
I’ve been poking around of late for a decent login.sql script that I can use and thought I’d share what […]
Managed Recovery – interrupted….
So today I had the good fortune of watching some fun unfold. Actually it was my fault as well, so […]
Optimizing Incremental Backups
As you (should) know, Oracle introduced the concept of the block change tracking file a while back (v10) to help shorten […]
RMAN and BIGFILE – hellish situations
I came across an interesting situation today in which an Exadata server hosts a database consisting solely of BIGFILE tablespaces. […]
DIY DBA – hobbyist or menace?
Musings on a consultant’s world. We’ve all met them. Either at work, on a project or in social interaction, the […]
Oracle’s ACFS clustered file system installation
Often in Oracle clustered database environments, a challenge can be finding somewhere to put common files – things like backups, […]