My Oracle Support Banner

Comparing ASM to Filesystem in benchmarks (Doc ID 1153664.1)

Last updated on APRIL 09, 2023

Applies to:

Oracle Database - Enterprise Edition - Version 12.2.0.1 to 12.2.0.1 [Release 12.2]
Oracle Database - Standard Edition - Version 10.2.0.5 to 10.2.0.5 [Release 10.2]
Oracle Database - Enterprise Edition - Version 12.1.0.2 to 12.1.0.2 [Release 12.1]
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Information in this document applies to any platform.

Purpose

There has been alot of incorrect methods on measuring performance between filesystems and ASM. This is particularily important for customers migrating from filesystem to an ASM based environment.  This document will, at a high-level, review the typical pitfalls when comparing or benchmarking filesystems to ASM.

Scope

The audience for this paper is System Admins and DBAs

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Scope
Details
 ASM Performance vs. Filesystems
 Problem:
 Background:
 Filesystem performance vs. ASM
 Leveling the playing field:
 Filesystem features and ASM
 o Read ahead pre-fetch
 o Filesystem Write I/O coalescing
 o Filesystem DirectIO
 Conclusion:
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.