Tag: oracle

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 AWR Report Format: Oracle 11.2.0.4 and 12c

This is a post about Oracle Automatic Workload Repository (AWR) Reports. If you are an Oracle professional you doubtless know what these are - and if you have to perform any sort of performance tuning as part of your day job it's likely you spend a lot of time immersed in them. Goodness knows I … Continue reading New AWR Report Format: Oracle 11.2.0.4 and 12c →

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 →

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 AWR Reports: Understanding I/O Statistics

One consequence of my job is that I spend a lot of time looking at Oracle Automatic Workload Repository reports, specifically at information about I/O. I really do mean a lot of time (honestly, I'm not kidding, I have had dreams about AWR reports). One thing that comes up very frequently is the confusion relating … Continue reading Oracle AWR Reports: Understanding I/O Statistics →