The ORACLEASM_USE_LOGICAL_BLOCK_SIZE parameter controls how ASMLib handles 4k Advanced Format devices – here's what it does and when you need to change it.
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.
Oracle AWR Reports: Understanding I/O Statistics
Oracle AWR reports contain multiple I/O sections that measure subtly different things – here's what each one actually captures and why conflating them leads to the wrong conclusions.
Oracle Fixes The 4k SPFILE Problem…But It’s Still Broken
Oracle patched the SPFILE failure on 4k devices in 11.2.0.4 – but the underlying support for Advanced Format storage remains incomplete and unreliable.
Playing The Data Reduction Lottery
Flash vendors routinely quote “effective capacity” figures based on optimistic data reduction assumptions – understanding what those numbers really mean is essential before signing a purchase order.
Oracle Exadata X4 (Part 2): The All Flash Database Machine?
With the X4's flash capacity changes examined, this post asks the harder question: is Oracle quietly turning Exadata into an all-flash array – and what would that mean for pricing?
Predictions for 2014: DataBase-as-a-Service
It's that time of year again where lots of people write articles which begin with the words "It's that time of year again..." and make endless references to crystal balls, tea leaves and the benefits of hindsight. But not me, I'm not descending into cliché. Apart from that first sentence, which with the benefit of … Continue reading Predictions for 2014: DataBase-as-a-Service
Oracle Exadata X4 (Part 1): Bigger Than It Looks?
The Exadata X4 announcement looked like a routine spec bump – but a closer reading of Oracle's positioning reveals something more significant about where the product is heading.
Storage Myths: Storage Compression Has No Downside
Storage-level compression trades capacity for CPU cycles and read latency – understanding that trade-off matters more than the headline reduction ratios vendors put in their datasheets.
Storage Myths: Dedupe for Databases
Data deduplication promises capacity savings, but databases are one of the worst use cases for it – the technology’s assumptions break down against the entropy and I/O patterns of database workloads.
The Most Expensive CPUs You Own
The most expensive CPUs in your data centre aren't the ones doing the most work – they're the ones sitting idle waiting for storage. Here's why I/O latency is a hidden CPU tax.
flashdba 