Re: CIO on AIX

A belated response ...

You can't use dbverify either, with the filesystemio_options=setall option on a jfs2 file system (which, as has been discussed, causes Oracle to use file-level CIO). Not sure if the same restriction exists for jfs/DIO.

• Original Message ---- From: "Allen, Brandon" <Brandon.Allen_at_OneNeck.com> To: "fmhabash_at_gmail.com" <cnewtonne_at_gmail.com>; Louis.Brouillette_at_uqtr.ca Cc: oracle-l_at_freelists.org Sent: Wednesday, February 21, 2007 12:05:36 PM Subject: RE: CIO on AIX

I've been running with filesystemio_options=setall and no cio mount option for 9 months with no problems. It sounds like the only problem Louis reported was with running user-managed hot backups, but we never do that and I can't really imagine why anybody would do it.

Louis, why don't you use rman?

-----Original Message-----
From: fmhabash_at_gmail.com [mailto:cnewtonne_at_gmail.com]

• Brandon has 10g, no cio, param set to 'setall' and his lsoft showed that files are opened with c_io.
• Louis has 10g, no cio, param set to 'setall' but he gets a crash. Mounting the fs with cio fixes it.
• looks like safest way to go is have both enabled (cio and setall) on 9i and 10g.

Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.

--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l