The Ultimate Guide To Oracle with Advanced Format 4k

fud

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 is everything I know. And from my desperate searching of the internet, plus discussions with people who are usually much knowledgeable than (more...)

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 will blog about this at some point…

For more details read this document from Red Hat.


Filed under: Blog, (more...)

Postcards from Storageland: Two Years Flash By

calendar

The start of March means I have been working at Violin Memory for exactly two years. This also corresponds to exactly two years of the flashdba blog, so I thought I’d take stock and look at what’s happened since I embarked on my journey into the world of storage. Quite a lot, as it happens…

Flash Is No Longer The Future

The single biggest difference between now and the world of storage I entered two (more...)

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, if you aren’t sure what I’m talking about here then please have a read of this page…)

In (more...)

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 buddy Nate who asked for this information: you rock, dude.

In more recent versions of ASMLib, Oracle introduced a new (more...)

Oracle AWR Reports: Understanding I/O Statistics

truth

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 to how the measurements of IOPS and throughput are displayed in the AWR report Load Profile section. The answer, (more...)

New script for setting up multipath.conf entries

I’ve added a new script to the Useful Scripts page called setup-violin-mpath.sh which automates the process of creating entries for the /etc/multipath.conf file on Red Hat 6 / Oracle Linux 6.

As the name suggests, I wrote it with Violin devices in mind, but there should be overlap with other storage which will potentially make it useful elsewhere… see here for more details.


Filed under: Blog, Flash, Linux, Storage Tagged: linux

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 truth be told, there were some holes.

(Before reading on, if you aren’t sure (more...)

Drill Down the I/O stack at UKOUG Tech13

It's just under a week to go before the doors open for the UKOUG Tech13 conference and the adjoining OakTable World UK 2013 sessions, so I thought I would write a very short blog post about what I will be doing there, where I'll be, and what I'm looking forward (more...)

Automatisches Lifecycle Management in 12c

Nur eine kurze Notiz: in 12c ist es möglich, die Storage von Daten auf unterschiedlicher Hardware und mit unterschiedlichen Eigenschaften (sprich: Komprimierung) über ILM (= Information Lifecyle Management) Optionen zu steuern. Einen einführenden Beitrag zum Thema findet man bei Martin Bach.

Death of the Storage Array

When I wrote this article for The Register in October 2010, there was a torrent of naysayers and witch hunters spewing their opinions in the comments section. I don't have a problem with that, I was only expressing an opinion myself, after all. I don't actually own a time machine (more...)

Optimal Oracle Configuration for Efficient Table Scanning (Part Three)

And finally, part three!  

How to detach storage device from running virtual machine in VirtualBox

In this post I want to show how to test what will happen with your cluster if you simply detach shared storage device from it. VirtualBox is great tool for that purpose because you can test such scenario without involving many people or causing any damage.

I am aware that (more...)

New Fact Finders Storage Video: Tale Of The Tape

This must see new video will show you how Lawrence Berkeley National Laboratory stores massive amounts of data using Oracle's Modular Tape Libraries.

New Podcast Series: Making The Right Storage Choices

Whether you are consolidating your storage, trying to improve application performance, or looking to get the most out of your databases, it’s important to ask the right questions. This 10 part podcast series examines the most important elements to consider when making storage purchasing or deployment decisions.

New E-Book: Oracle Optimized Storage For Private Cloud & Virtualization

Download your copy of the Oracle Optimized Storage: Innovation for Private Clouds and Virtualization e-book, and discover the benefits customers have realized by deploying Oracle storage in virtualized and private cloud environments.

New Storage Podcast Series Highlights 10 Important Purchase Considerations

Whether you are new to storage or a seasoned professional, deciding which storage systems to buy can have a big impact on how your business performs. There are a lot of factors to consider and each one should be weighed in light of the impact it will have on your (more...)

When You Should Consider Flash for Database Storage

@flashdba:

If any of this is ticking boxes for you, it’s time to consider what flash could do for the performance of your database:
  • I/O wait times are high. Essentially we are looking for high latency from the existing storage system. Flash memory systems should deliver I/O with sub-millisecond (more...)

Optimal Oracle Configuration for Efficient Table Scanning (Part Two)

Here's part two!

Optimal Oracle Configuration for Efficient Table Scanning (Part One)

I just got permission from The UK Oracle Users Group to reproduce my article series on optimising scans in Oracle. Part One is available here, Part Two will follow shortly after, and then Part Three will be a few weeks away, following its publication in the magazine. Enjoy!