Re: qio, async_io and control files

hi,

controlfiles make no sense for quio

but
 online logs
 datafiles
 tempfiles

are good for qio

have you evaluated ODM with Oracle 9i and veritas ??

"NetComrade" <andreyNSPAM_at_bookexchange.net> schrieb im Newsbeitrag news:3f12eb82.600408281_at_nyc.news.speakeasy.net...
> Hi,
>
> We use the qio product, and all data files are qio.
> trussing ora_<SID>_dbwr shows that most calls success as successful
> kaio calls (asyc_io is set to true)
> However, trussing ora_<SID>_ckpt shows that kaio calls fail 3 times in
> a row to different files, since there are 3 such calls and I have 3
> control files and control files are not qio files, I assume it's for
> control files (if anybody can teach me how to read parameters of kaio
> calls, i'd be very happy!)
>
> Since control files are frequently updated should this be my concern?
> The reason why control files are not qio files, is b/c I don't know
> their size in advance, and they grow over time, if there is a way to
> create them as qio files, i'd be happy for that info as well. Is there
> are a way to not let oracle issue direct io against control files?
>
> Thanks in advance.
>
>
> kaio(AIOWRITE, 299, 0x01A69EA0, 4096, 12288, 0x01A67EA8) Err#48
> ENOTSUP
> lwp_cond_signal(0xFEB21FA0) = 0
> lwp_cond_wait(0xFEB21FA0, 0xFEB21FB0, 0x00000000) = 0
> kaio(AIOWRITE, 298, 0x01A69EA0, 4096, 12288, 0x01A67DCC) Err#48
> ENOTSUP
> pwrite64(299, "1502\0\0\0\0\003\001 ]84".., 4096, 12288) = 4096
> lwp_cond_signal(0xFEB0FFA0) = 0
> lwp_cond_wait(0xFEB0FFA0, 0xFEB0FFB0, 0x00000000) = 0
> kaio(AIOWRITE, 297, 0x01A69EA0, 4096, 12288, 0x01A680F4) Err#48
> ENOTSUP
> pwrite64(298, "1502\0\0\0\0\003\001 ]84".., 4096, 12288) = 4096
>
>
> .......
> We use Oracle 8.1.7.4 on Solaris 2.7 boxes
> remove NSPAM to email
Received on Wed Jul 16 2003 - 06:39:36 CDT