Last week I attended Oracle OpenWorld 2013 in the stunning city of San Francisco, along with 60,000 other attendees. At times it felt like we'd taken over the entire city, with every street, bus, billboard and hotel plastered in Oracle logos and pictures of engineered systems... although apparently there was some other stuff going on … Continue reading OOW13: The Future Is Here (Just Don’t Mention “Legacy”)
Tag: Databases
Databases are the systems of record at the heart of the enterprise. They were designed for correctness, durability, and human-paced interaction – not for continuous, machine-driven access patterns.
As workloads evolve, the database remains the point of truth… but the assumptions around how it is accessed are starting to break.
The Real Cost of Oracle RAC
Oracle RAC is sold as a high-availability solution, but its real cost – in licenses, complexity and the hidden assumption that losing a node doesn’t count as an outage – is rarely made explicit.
The Real Cost of Enterprise Database Software
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.
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
Using SLOB2 to measure how Oracle's database block size affects physical I/O performance – with results that challenge some common assumptions about blocksize tuning.
SLOB: PL/SQL Commit Optimization
A curious SLOB result reveals how Oracle's PL/SQL engine optimises commits in ways that affect benchmark results – and what it means for workload testing methodology.
SLOB2: Essential for Every DBA Toolkit
SLOB2 – the Silly Little Oracle Benchmark – is the most reliable way to generate controlled physical I/O on Oracle. Here's why every DBA should have it and how to get started.
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.
flashdba 