Storage for DBAs: "My database is slow"... "Well then why not put your redo logs on SSDs?" Gaaaah. I still hear people having this discussion and it drives me mad. "Nobody got fired for putting Oracle redo on ...<flash vendor>". Yeah right, but does that mean it was worth the investment? I'm bored of this … Continue reading Storage Myths: Put Oracle Redo on SSD
Blog
7 Steps to Guarantee People Will Read Your Posts
I see this type of article pop up all the time on places link LinkedIn and SlideShare. Here's my response... Choose an arbitrary number of items, e.g. 7 Combine this with a suitable noun that the number will describe, e.g. steps, tips, ways, methods etc Make sure you put this combination at the start of … Continue reading 7 Steps to Guarantee People Will Read Your Posts
Storage Myths: IOPS Matter
Storage for DBAs: Having now spent over a year in the storage industry, I've decided it's time to call out an industry-wide obsession that I previously wasn't aware of: everyone in storage is obsessed with IOPS (the performance metric I/O Operations Per Second). Take a minute to perform a web search for "flash iops" and … Continue reading Storage Myths: IOPS Matter
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
New SLOB2 Physical I/O Harness
Short post to point out that I've now posted the updated PIO Test Harness for SLOB2. This can be used to run multiple SLOB tests with varying numbers of workers and values of UPDATE_PCT. In addition there is also a revised version of the AWR analyzer shell script which can be used to extract various … Continue reading New SLOB2 Physical I/O Harness
SLOB: PL/SQL Commit Optimization
I ran some SLOB tests over the weekend using the new SLOBv2 kit and noticed some interesting results. I was using SLOB to generate physical I/O but the "anomaly" is best demonstrated by putting SLOB in "Logical I/O mode", i.e. by having a large enough buffer cache to satisfy all reads. I'm calling SLOB with the … Continue reading SLOB: PL/SQL Commit Optimization
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
The Most Important Thing You Need To Know About Flash
NAND flash development is driven by the consumer market – not the enterprise. The question to ask any flash vendor isn't "how fast?" but "where's your innovation?"
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 