I’m working on a project with a series of Oracle databases holding SAP data. To make it fun, the data […]
Archive for ‘Database’
Friends, Romanulans, countrymen, lend me your pointy ears. 2016 was an interesting year – terror, political upheaval and horror of […]
The other day, I was working on a fuzzy recovery thanks to some ugly Netapp snapshot “capabilities” and I came […]
Speeding up conversion processes – hacking commits.
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 […]
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. […]
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, […]
Oracle Flashback Table and Recycle Bin demos
So in conversation the other day, it became clear that there’s a few things that can be best clarified with […]