Oracle SLOB On Solaris

SLOB is primarily a Linux tool, but it runs on Solaris too – here's the configuration required and the key differences to watch out for when benchmarking Oracle I/O on Solaris.

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.

SLOB using Violin 6616 on Fujitsu Servers

I've been too busy to blog recently, which is frustrating because I want to talk more about subjects that are important to me such as Database Virtualization and the great hype around In Memory Databases. However, in the meantime I'd like to share some results from running SLOB (the Silly Little Oracle Benchmark) on Violin … Continue reading SLOB using Violin 6616 on Fujitsu Servers →

SLOB on Violin 3000 Series with PCIe Direct Attach

A reader Alex asked if I could post a comparative set of tests from my previous 3000 series Infiniband testing but using the PCIe direct-attached method. I was actually very keen to test this myself as I wanted to see how close the Infiniband connectivity method could get to the PCIe latencies. Why? Well, PCIe … Continue reading SLOB on Violin 3000 Series with PCIe Direct Attach →

SLOB on Violin 3000 Series with Infiniband

SLOB benchmark results from Martin Bach's hands-on testing of a Violin 3000 series flash array connected via Infiniband – comparing latency and throughput against PCIe-based flash.

SLOB testing on Violin and Exadata

A head-to-head SLOB benchmark comparing Violin flash memory arrays against Oracle Exadata – testing raw Oracle physical I/O throughput on two very different architectures.