My Oracle Support Banner

Datafile creation on Mirrored Disks is Twice as Slow as on Non-Mirrored Disks (Doc ID 1382611.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.2 and later
IBM AIX on POWER Systems (64-bit)
***Checked for relevance on 01-Sep-2017***

Symptoms

The CREATE TABLESPACE command, creating 64Gb datafiles on mirrored and non-mirrored disk shows a big difference in elapsed time, e.g. a duration of 10 minutes for mirrored and 5 minutes for non-mirrored.

Changes

I/O was configured to enable both ASYNC and DIRECT IO (or Concurrent I/O) like in below situation 1.

1) Initial parameters were:

filesystemio_option=setall
disk_asynch_io=true
Mirrored disks = 10 minutes
Non-mirrored disks = 5 minutes


Testing different settings as below:

2)  Forcing Direct I/O

filesystemio_option=directio
disk_asynch_io=true (or false)
Mirrored disks = 10 minutes
Non-mirrored disks = 5 minutes


3)  Forcing Async I/O

filesystemio_option=asynch
disk_asynch_io=true
Mirrored disks = 4.5 minutes
Non-mirrored disks = 4.5 minutes

Cause

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
Symptoms
Changes
Cause
Solution
References


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