qio, async_io and control files

From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: Mon, 14 Jul 2003 17:53:45 GMT
Message-ID: <3f12eb82.600408281@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 Mon Jul 14 2003 - 12:53:45 CDT