It came to my attention last November that I had crossed the one year anniversary since my last post on flashdba.com. I was so surprised that I immediately decided to write a new post, which took another three months. There are reasons why I'm no longer posting technical blogs about databases and flash, but I'll … Continue reading Oracle ASM and Thin Provisioning – How To Reclaim Space
Category: ASM
Oracle’s ASM Filter Driver Revisited
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
ASM Rebalance Too Slow? 3 Tips To Improve Rebalance Times
I've run into a few customers recently who have had problems with their ASM rebalance operations running too slowly. Surprisingly, there were some simple concepts being overlooked - and once these were understood, the rebalance times were dramatically improved. For that reason, I'm documenting the solutions here... I hope that somebody, somewhere benefits... 1. Don't … Continue reading ASM Rebalance Too Slow? 3 Tips To Improve Rebalance Times
Viewing ASM trace files in VIM: Which Way Do You Use?
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?
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
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
Oracle Exadata X4 (Part 2): The All Flash Database Machine?
This article looks at the new Oracle Exadata X4-2 Database Machine from Big Red. In part one I looked at the changes made from the X3 model (more stuff) as well as the implications (more license bills). I also covered some of the confusing and bewildering descriptions Oracle has used to describe the flash capacity … Continue reading Oracle Exadata X4 (Part 2): The All Flash Database Machine?
flashdba 