Datafile creation on Mirrored Disks is Twice as Slow as on Non-Mirrored Disks

(Doc ID 1382611.1)

Last updated on NOVEMBER 28, 2017

Applies to:

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


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.


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

1) Initial parameters were:

Mirrored disks = 10 minutes
Non-mirrored disks = 5 minutes

Testing different settings as below:

2)  Forcing Direct I/O

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

3)  Forcing Async I/O

Mirrored disks = 4.5 minutes
Non-mirrored disks = 4.5 minutes


Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms