RE: Migrate from AIX to Linux

From: Rich J <rjoralist3_at_society.servebeer.com>
Date: Thu, 17 Dec 2015 15:50:49 -0600
Message-ID: <93cd4a5058a951bef86b297080af046a_at_society.servebeer.com>

On 2015/12/17 15:00, Dimensional DBA wrote:

> CIO is redundant to Oracle overall I/O and caching mechanisms. You should use Oracle ASM on Linux.

OK, you've got me curious now. With Oracle 10g+ on AIX, where filesystemio_options=setall and the database files are on JFS2, DBWR will implicitly use CIO, even if CIO isn't specified on the mountpoint. CIO should not be used anywhere else for the database (e.g. not on redo logs or binaries), per Oracle and IBM.

Are you saying that one should purposely _not_ use CIO on AIX? It seems like that would incur performance penalties for the DBWR, including dbfile creation/extension and restores.

Rich

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

Received on Thu Dec 17 2015 - 22:50:49 CET

This message: [ Message body ]
Next message: Kellyn Pot'Vin-Gorman: "Re: Weird Server Slowdown due to Cloud Control / Enterprise Manager DB"
Previous message: Andrew Kerber: "Re: upgrade OL6 tot OL7 within Cluster"
Maybe in reply to: Dimensional DBA: "RE: Migrate from AIX to Linux"
Next in thread: Dimensional DBA: "RE: Migrate from AIX to Linux"
Reply: Dimensional DBA: "RE: Migrate from AIX to Linux"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message