When You Should Consider Flash for Database Storage


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!

New analyst report on ZFS Storage Appliance

Industry analysts from Storage Strategies Now recently released a report comparing Oracle's Sun ZFS Storage Appliance to NetApp, EMC VNX and Isilon.  

The report is available now at:  http://www.oracle.com/us/products/servers-storage/storage/nas/oracle-storage-update-ssg-now-1933211.pdf.



Power DBaaS with Sun ZFS Storage Appliance

If you have been thinking about setting up a DBaaS (Database as a Service) for your company you won't want to miss this webcast about implementing DBaaS using Oracle Enterprise Manager 12c and Oracle Sun ZFS Storage Appliance. In this webcast you will learn about the features and benefits that the (more...)

Is Tape Storage Still Harder to Manage Than Disk Storage?

| Mar 28, 2013


-guest post by Brian Zents-

Historically, there has been a perception that tape is more difficult to manage than disk, but why is that? Fundamentally there are differences between disk and tape. Tape is a removable storage medium and disk is always powered on and spinning. With a removable (more...)

Optimized Storage for DB Workloads

Today’s Enterprise database workloads require storage devices that must embed a variety of features so that the optimal level of performance, manageability and operational agility can be achieved. Even if most Enterprise Database products have the ability to rely on their own file system to optimize access to storage, there (more...)

NEW: Tape Storage Upgrade Guide – Modernize Your Storage Infrastructure With The Latest Oracle StorageTek Tape Solutions

This interactive guide is a great place to start a conversation with your Tape customers about what they could achieve with a modern tape infrastructure. It features:

A chapter on each of our latest StorageTek Tape products, with explanation of (more...)

Diagnosing ASMlib

To use ASMlib or not to use ASMlib? That is the question. Or at least, that is a question that frequently crops up when I'm on consulting engagements with customers. I have personally changed my mind a couple of times on this exact question, and I'm currently sat with one leg on either side of [...]

System Architecture Series: Introduction to the Series and Licensing

This blog post is an introduction to a few posts that can be grouped together under the banner of 'System Architecture'. Specifically, I'm referring here to Oracle Database System Architecture, not system architecture in general nor 'Oracle architecture' in general, which is an ever-growing beast. In this series of posts, I will take at look [...]

The effect of ASM redundancy/parity on read/write IOPS – SLOB test case! for Exadata and non-Exa environments

Last week I had a lengthy post at oracle-l that tackles Calibrate IO, Short Stroking, Stripe size, UEK kernel, and ASM redundancy effect on IOPS Exadata which you can read here
followed by interesting exchange of tweets with Kevin Closson here (see 06/21-22 tweets) which I was replying in between games at UnderwaterHockey US Nationals 2012 which we won the championship for the B division ;) I have my awesome photo with the medal here

This post will detail on the ASM redundancy/parity effect on IOPS… if… by changing the ASM redundancy (external, normal, and high) will it decrease the workload (more...)

NetApp’s ExaData Backup Play Reprise

I have received a fair number of responses to my previous post on this subject (some via comments and some via email). I thought the discussion worthwhile enough to punch it up a bit more here.


As I pointed out in the previous post, EMC can easily match NetApp's play to back up ExaData with the following:


As Geoff Rosser so correctly pointed out, this answer is incomplete. Yes, Data Domain is an awesome Oracle backup solution. Yes, it provides incredible deduplication rates for Oracle database environments. (Thanks, dynamox.) However, it is not the only viable solution from (more...)

Troubleshooting ASM 11.2 disk discovery

I was doing some installation at customer site when they asked if there anything specific to run GI 11.2 on HP-UX as this was their first interaction with 11g. Of course I replied that there is nothing specific, just to make sure the ownership of the raw disk is correct and had a correct ASM discovery string. They said that this is all done as it’s written in the documentation, but disks could not be discovered. This made me curious and asked them to log me in the system so I could have a look.

The system was running (more...)

Oracle datafile IO latency – Part 1

On my post about observing the Exadata V1 I had an interesting comment posted by Mark Seger (author of collectl and collectl utilities) about the correlation of activities across a system, the sample and snap time, and seeing the state of the subsystem before and after

The comment made me curious about the effect of snap intervals on the performance numbers of the datafiles and block devices.. especially on the latency numbers.. so I made a few test cases and created some scripts that would give me 5 seconds, 10 minutes, and 60 minutes output of (more...)