Almost exactly a year ago I published a post covering my first impressions of the ASM Filter Driver (ASMFD) released in Oracle 12.1.0.2, followed swiftly by a second post showing that it didn't work with 4k native devices. When I wrote that first post I was about to start my summer holidays, so I'm afraid … Continue reading Oracle’s ASM Filter Driver Revisited
Tag: advanced format
Oracle 12.1.0.2 ASM Filter Driver: Advanced Format Fail
[Please note that a more up-to-date post on this subject can be found here] In my previous post on the subject of the new ASM Filter Driver (AFD) feature introduced in Oracle's 12.1.0.2 patchset, I installed the AFD to see how it fulfilled its promise that it "filters out all non-Oracle I/Os which could cause accidental overwrites". … Continue reading Oracle 12.1.0.2 ASM Filter Driver: Advanced Format Fail
Oracle 12.1.0.2 ASM Filter Driver: First Impressions
This is a very quick post, because I'm about to log off and take an extended summer holiday (or vacation as my crazy American friends call it... but then they call football "soccer" too). Before I go, I wanted to document my initial findings with the new ASM Filter Driver feature introduced in this week's … Continue reading Oracle 12.1.0.2 ASM Filter Driver: First Impressions
New My Oracle Support note on Advanced Format (4k) storage
In the past I have been a little critical of Oracle's support notes and documentation regarding the use of Advanced Format 4k storage devices. I must now take that back, as my new friends in Oracle ASM Development and Product Management very kindly offered to let me write a new support note, which they have … Continue reading New My Oracle Support note on Advanced Format (4k) storage
The Ultimate Guide To Oracle with Advanced Format 4k
It's a brave thing, calling something the "Ultimate Guide To ..." as it can leave you open to criticism that it's anything but. However, this topic - of how Oracle runs on Advanced Format storage systems and which choices have which consequences - is one I've been learning for two years now, so this really … Continue reading The Ultimate Guide To Oracle with Advanced Format 4k
New installation cookbook for SUSE Linux Enterprise Server 11 SP3
Exactly what it says on the tin, I've added a new installation cookbook for SUSE 11 SP3 which creates Violin on a set of 4k devices. I've started setting the add_random tunable of the noop I/O scheduler because it seems to give a boost in performance during benchmarking runs. If I can find the time, I … Continue reading New installation cookbook for SUSE Linux Enterprise Server 11 SP3
More Problems with Oracle’s Support of 4k Devices
This is going to be another one of those posts, a bit like this one, that discuss the use of Oracle's database product with Advanced Format devices. I wish there weren't so many of these posts, but it seems that Oracle has a lot of issues with it's implementation of 4k support. (Before reading on, … Continue reading More Problems with Oracle’s Support of 4k Devices
Oracle ASMLib: Physical and Logical Blocksize
This article is about the use of Advanced Format devices on Oracle's ASMLib kernel library for Linux. For background, read this page on 4k sector sizes first, otherwise it might all sound like nonsense. Mind you, it mind sound like nonsense anyway, I can't guarantee anything here. By the way, a big hello to my … Continue reading Oracle ASMLib: Physical and Logical Blocksize
Oracle Fixes The 4k SPFILE Problem…But It’s Still Broken
As anyone familiar with the use of Oracle on Advanced Format storage devices will know to their cost, Oracle has had some difficulties implementing support of 4k devices. Officially, support for devices with a 4096 byte sector size was introduced in Oracle 11g Release 2 (see section 4.8.1.4 of the New Features Guide) but actually, if the … Continue reading Oracle Fixes The 4k SPFILE Problem…But It’s Still Broken
flashdba 