Re: CIO on AIX

Thank you that point me out at dynamic behaviour of the parameter.

For the database the filesystemio_options parameter is not installed in init file so it should asynch by default but there is a very interesting response I got:

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production With the Partitioning option
JServer Release 9.2.0.6.0 - Production

SQL> sho parameter systemio

NAME                                 TYPE        VALUE
------------------------------------ -----------
------------------------------
filesystemio_options                 string      asyncche_size

Definitely, a request must be opened on Metalink. Regards,
Andrey Goryunov

On 21/02/07, fmhabash_at_gmail.com <cnewtonne_at_gmail.com> wrote:
>
> I have worked on this issue with both IBM and Oracle. This is the final
> version of my investigation and what I implement on the databases here.
> I see you mostly used some of the reference I did.
>
> - Mount FS with CIO for DFs, redo, and archive dest. Do NOT use with CFs
> and OH.
> - On 9i, change file system options to 'setall'
> - Do NOT use JFS with DIO or JFS with large file enabled.
> - Enable large page support
> - disable VMM from steeling pages from the SGA
>
> What is your current setting for the filesystem options? If still at
> default, change to 'setall' dynamically and see if you can see the
> direct IO calls now.
>

-- 
Sincerely,
Andrey Goryunov.

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