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.
Tag: flash memory
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.
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.
Database Workload Theory
Before you can benchmark or optimise a database, you need a model of what a database workload actually is. Here's the theoretical foundation – and why it matters more than most DBAs realise.
Flash Enables Human-Time Analytics
Analytics has always been constrained by storage latency – queries that take hours are useless for real-time decisions. Flash collapses that latency and makes human-time analytics possible.
flashdba 