RE: About AIX configuration for Oracle
- From: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
- To: "dbvision@xxxxxxxxxxxx" <dbvision@xxxxxxxxxxxx>, "gil.cota@xxxxxxxxxx" <gil.cota@xxxxxxxxxx>, "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 20 Oct 2009 09:44:21 -0700
On a related topic, I recently started looking into implementing flashback
database for my 10.2.0.2 database on AIX 5.3, however it wasn't clear to me if
the flashback logs should be on a filesystem mounted with the CIO option or
not, so I did some research and as usual came up with conflicting advice, so
then I opened an SR for clarification and unfortunately was given the wrong
answer. Only after testing myself and verifying by checking the open flashback
log files with lsof was I able to confirm that Oracle does indeed open the
flashback logs with the cio flag automatically if you have
filesystemio_options=setall, so it appears that concurrent I/O should be used
for flashback logs (despite what the documentation and Metalink notes say), and
that it is automatically used if you set filesystemio_options=setall, just like
it is automatic for data files, control files and redo log files, so you don't
need to create a separate filesystem for it.
Regards,
Brandon
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Nuno Souto
Also please note that how Oracle handles Concurrent IO changes from patch level
to patch level: you must check what yours is doing with truss.
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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
