A couple of people have asked me recently about a classic problem that most DBAs know: how to view ASM trace files in the VIM editor when the filenames start with a + character. To my surprise, there are actually quite a few different ways of doing it. Since it's come up, I thought I'd … Continue reading Viewing ASM trace files in VIM: Which Way Do You Use?
Tag: oracle
Oracle 12.1.0.2 ASM Filter Driver: Advanced Format Fail
The ASM Filter Driver introduced in Oracle 12.1.0.2 as a replacement for ASMLib has a critical flaw: it fails entirely with 4k native Advanced Format devices.
Oracle 12.1.0.2 ASM Filter Driver: First Impressions
Oracle's new ASM Filter Driver in 12.1.0.2 promises cleaner I/O filtering than ASMLib – here are the initial installation findings and what to watch out for with 4k devices.
New AWR Report Format: Oracle 11.2.0.4 and 12c
Oracle quietly changed the AWR report format in 11.2.0.4 and 12c – here's what moved, what's new and what DBAs relying on the old layout need to know.
New My Oracle Support note on Advanced Format (4k) storage
A new official Oracle support note on Advanced Format 4k storage – co-authored with Oracle ASM Development to replace the confusing and inconsistent guidance that existed before.
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.
The Ultimate Guide To Oracle with Advanced Format 4k
Everything you need to know about running Oracle on Advanced Format 4k storage – a high-level overview and a full Oracle deep dive, in one place.
More Problems with Oracle’s Support of 4k Devices
Bypassing ASM and using a filesystem doesn't escape Oracle's 4k compatibility issues – here's what breaks when you put Oracle on a 4k native device without ASM.
Oracle ASMLib: Physical and Logical Blocksize
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.
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.
flashdba 