Oracle database licensing is eye-wateringly expensive per CPU core – and storage costs, often seen as prohibitive, represent a surprisingly small fraction of the total three-year spend.
The Real Cost of Enterprise Database Software
Tag: oracle
Storage Myths: Put Oracle Redo on SSD
Putting Oracle redo logs on SSD is a common reflex response to slow databases – but it usually misdiagnoses the problem, and SSDs handle write-heavy sequential workloads worse than you might expect.
Storage Myths: IOPS Matter
IOPS figures dominate flash storage marketing, but for databases latency is the metric that matters – high IOPS at unpredictable latency deliver no real-world value.
The Role Of The DBA
I'm back at work today after a week's travelling around Europe followed by a week's holiday sailing around the Ionian Sea. I have to say that I'd rather still be on holiday. It's not that I don't enjoy my job (I love it) but... Today, I need to install some database software - and it … Continue reading The Role Of The DBA
SLOB2: Testing The Effect Of Oracle Blocksize
I recently posted a test harness for generating physical I/O using the new version of SLOB (the Silly Little Oracle Benchmark) known as SLOBv2. This test harness can be used for driving varying workloads and then processing the results for use in ... well, wherever really. Some friends of mine are getting very adept with … Continue reading SLOB2: Testing The Effect Of Oracle Blocksize
SLOB2: Essential for Every DBA Toolkit
A couple of weeks ago, Kevin released the second version of SLOB - the Silly Little Oracle Benchmark. Readers will know that I was already a big fan of the original version, but version 2 (which I was fortunate enough to test prior to its release) now has extra features and functionality which make it … Continue reading SLOB2: Essential for Every DBA Toolkit
Does My Database Need Flash?
Not every database benefits from flash storage – knowing when it matters requires understanding how much I/O your workload generates, how random it is and how much latency is already costing you.
Understanding I/O: Random vs Sequential
Disk I/O forces a choice between random and sequential access – and that choice defines whether latency compounds or disappears. Flash makes the distinction irrelevant.
Strange ASM Behaviour with 4k Devices
This is only a short post to document something I've seen and reproduced but still don't understand. Storage devices generally have a physical sector size of 512 bytes or, more recently, 4k. This is a subject which causes much confusion (partly because some vendors seek to portray whichever sector size they use as "better"). You … Continue reading Strange ASM Behaviour with 4k Devices
AWR Generator
As part of my role at Violin I spend a lot of time profiling customer's databases to see how their performance varies over time. The easiest way to do this (since I often don't have remote access) is to ask for lots of AWR reports. One single report covering a large span of time is … Continue reading AWR Generator
flashdba 