Re: Oracle 11.2 on AIX 7.1 JFS2 mount options
From: Rich J <rjoralist3_at_society.servebeer.com>
Date: Wed, 21 Dec 2016 14:11:49 -0600
Message-ID: <941f2c47f050673d0deedd907619cde1_at_society.servebeer.com>
Date: Wed, 21 Dec 2016 14:11:49 -0600
Message-ID: <941f2c47f050673d0deedd907619cde1_at_society.servebeer.com>
On 2016/12/21 13:46, Martin Klier - Performing Databases GmbH wrote:
> I am calling out for Oracle-on-AIX knowledge/experience bearers, and have a question whether setting the "cio" mount option for datafiles, redo logs and control files for DB version 11.2.0.4 on AIX 7.1 with JFS2 or not.
>
> We are using filesystemio_options=setall for this customer setup.
>
> ...
>
> Simple question:
> I have massively concurrent IO on datafiles (usual read/write activity) and redo logs (streams capture) with many (so far unavoidable) "db file sequential read" and "log file sync" waits.
> Should I activate JFS2 mount option -cio for my data files and redo log file systems?
GL!
Rich
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Dec 21 2016 - 21:11:49 CET