Oracle Exadata X5: The Road To Ten Billion Dollars

Now that the dust has settled on the announcement of Oracle's new Exadata X5 Database Machine, I've been doing some research in order to update my History of Exadata post (it'll be ready soon). While reviewing the datasheets and other collateral for the X5 I was struck by the meteoric increase in one particular statistic: the … Continue reading Oracle Exadata X5: The Road To Ten Billion Dollars →

Oracle AWR Reports: When IOStats Lie

If you've been unfortunate enough to follow my dithering on Twitter recently you'll know that I've been lurching between thinking that there is and isn't a problem with Oracle's tracking of I/O statistics in its AWR reports. I'm now convinced there is a problem, but I can't work out what causes it... so step 1 … Continue reading Oracle AWR Reports: When IOStats Lie →

New Cookbook: Oracle Linux 6 Update 5 within an Oracle VM Template

I've posted a new installation cookbook for using Oracle within a virtual machine running on Oracle VM. Surprisingly, I was unable to come up with a satisfactory method of accessing external storage that did not involve the use of Oracle ASMLib... Oracle Linux 6 Update 5 within an Oracle VM Template

Oracle AWR Reports: When Averages Lie

I was recently contacted by a customer who runs a busy ERP system on their Oracle database. Their users have been screaming for some time about unpredictable performance, where application screens which would usually open in under a second suddenly take an age. ERP systems are legendary for this, of course, because as each screen … Continue reading Oracle AWR Reports: When Averages Lie →

Oracle, Parallelism and Direct Path Reads… on Flash

Guest Post This is another guest post from my buddy Nate Fuzi, who performs the same role as me for Violin but is based in the US instead of EMEA. Because he's an American, Nate believes that "football" is played using your hands and that the ball is actually egg-shaped. This is of course ridiculous, … Continue reading Oracle, Parallelism and Direct Path Reads… on Flash →

Viewing ASM trace files in VIM: Which Way Do You Use?

A couple of people have asked me recently about a classic problem that most DBAs know: how to view ASM trace files in the VIM editor when the filenames start with a + character. To my surprise, there are actually quite a few different ways of doing it. Since it's come up, I thought I'd … Continue reading Viewing ASM trace files in VIM: Which Way Do You Use? →

Oracle 12.1.0.2 ASM Filter Driver: Advanced Format Fail

[Please note that a more up-to-date post on this subject can be found here] In my previous post on the subject of the new ASM Filter Driver (AFD) feature introduced in Oracle's 12.1.0.2 patchset, I installed the AFD to see how it fulfilled its promise that it "filters out all non-Oracle I/Os which could cause accidental overwrites". … Continue reading Oracle 12.1.0.2 ASM Filter Driver: Advanced Format Fail →

Oracle 12.1.0.2 ASM Filter Driver: First Impressions

This is a very quick post, because I'm about to log off and take an extended summer holiday (or vacation as my crazy American friends call it... but then they call football "soccer" too). Before I go, I wanted to document my initial findings with the new ASM Filter Driver feature introduced in this week's … Continue reading Oracle 12.1.0.2 ASM Filter Driver: First Impressions →

New AWR Report Format: Oracle 11.2.0.4 and 12c

This is a post about Oracle Automatic Workload Repository (AWR) Reports. If you are an Oracle professional you doubtless know what these are - and if you have to perform any sort of performance tuning as part of your day job it's likely you spend a lot of time immersed in them. Goodness knows I … Continue reading New AWR Report Format: Oracle 11.2.0.4 and 12c →

New section: Oracle SLOB Testing

For some time now I have preferred Oracle SLOB as my tool for generating I/O workloads using Oracle databases. I've previously blogged some information on how to use SLOB for PIO testing, as well as shared some scripts for running tests and extracting results. I've now added a whole new landing page for SLOB and … Continue reading New section: Oracle SLOB Testing →