ODA : Enabling Local File System Auditing Can Greatly Slow Down the Database IO Performance (Doc ID 2088220.1)

Last updated on DECEMBER 28, 2015

Applies to:

Oracle Database Appliance X3-2 - Version All Versions to All Versions [Release All Releases]
Oracle Database Appliance X4-2 - Version All Versions to All Versions [Release All Releases]
Information in this document applies to any platform.

Symptoms

SQL that is known to run in 100 ms on another ODA is only taking 5s on a different ODA:

With syslog running the SQL consistently takes 100s to run.  
With syslog stopped the same SQL consistently takes 5m.

[kjournald]
syslogd -m 0

The symptoms can be confirmed in the OSW output including IOSTAT


...
...
sdaw    0.00 204.00  0.00 196.00 0.00 1604.00   16.37  1.32  6.74  4.85  95.00
sdaw1  0.00    0.00   0.00    0.00 0.00       0.00    0.00  0.00  0.00  0.00    0.00
sdaw2  0.00 204.00  0.00 196.00 0.00  1604.00  16.37  1.32  6.74  4.85  95.00
sdaw    0.00   74.00  0.00 166.00 0.00   964.00  11.61  0.98  5.92  5.78  95.90

 

 

  

Changes

 Enabled audit file on local file system.

Cause

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