Re: Oracle 11.2 on AIX 7.1 JFS2 mount options
Date: Wed, 21 Dec 2016 22:27:23 +0100 (CET)
Message-ID: <550851255.1294515.1482355643627.JavaMail.open-xchange_at_app02.ox.hosteurope.de>
> Still open questions: Is this SAP Note's advice still valid for AIX 7.x ?
Please forget the SAPnote and read the mentioned paper or let me quote the corresponding part from it: "AIX 6.1 and AIX 7.1 combined with Oracle >=
11.2.0.2 introduced a new open flag O_CIOR which is same as O_CIO, but this allows subsequent open calls without CIO. The advantage of this
enhancement is that other applications like cp, dd, cpio can access database files in read only mode without having to open them with CIO. Starting
with Oracle 11.2.0.2 when AIX 6.1 or AIX 7.1 is detected, Oracle will use O_CIOR option to open a file on JFS2. Therefore you should no longer mount
the filesystems with mount option –o cio."
> My big question is if O_CIOR really does the same per file as O_CIO does for the file system.
Freelance Oracle performance consultant and researcher
Homepage: http://www.soocs.de
Twitter: _at_OracleSK
> Martin Klier - Performing Databases GmbH <martin.klier_at_performing-db.com> hat am 21. Dezember 2016 um 21:29 geschrieben:
>
> Stefan, sometimes you are frightening me. :)
> Thanks, will look that paper up.
>
> Still open questions: Is this SAP Note's advice still valid for AIX 7.x ?
> My big question is if O_CIOR really does the same per file as O_CIO does for the file system. The SAP note seems to tell otherwise.
>
> But if I am not allowed to set CIO any more, how can I get concurrent WRITE capability?
>
>
> --
> Martin Klier | Performing Databases GmbH
> Managing Partner | Senior DB Consultant
> Oracle ACE
>
> martin.klier_at_performing-db.com | http://www.performing-databases.com
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Dec 21 2016 - 22:27:23 CET