| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: init.ora params for quick i/0
There would be an error value at the end of the call, and the next call
would
be a standard write call ( pwrite I think ).
Jared
Mohammed.Ahsanuddin_at_VerizonWireless.com
Sent by: root_at_fatcity.com
05/21/2002 02:29 PM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
cc:
Subject: RE: init.ora params for quick i/0
Jarred,
Here is a sample what I get from truss..There are no error messages saying which indicates that AIO calls are falling back to standard IO calls...Is there any other way of identifying that?
And also thanks for the book suggestion..I was waiting for a newer release though, but will go with the current one.
24230: kaio(AIOWAIT, 0xFFBEDF78) = 28239248 24228: kaio(AIOWRITE, 369, 0x88BC0000, 8192, 0x3B75A000, 0x01BA7234) = 0 24228: kaio(AIOWRITE, 355, 0x89E9C000, 8192, 0x1AF46000, 0x01BA13E8) = 0 24228: kaio(AIOWRITE, 365, 0x89704000, 8192, 0x3B998000, 0x01B822E0) = 0 24228: kaio(AIOWRITE, 365, 0x89532000, 8192, 0x3BA28000, 0x01B66BA8) = 0 24228: kaio(AIOWRITE, 365, 0x8986C000, 8192, 0x3BAFC000, 0x01BAEE1C) = 0 24228: kaio(AIOWAIT, 0xFFBEDF78) = 28844768 24228: kaio(AIOWAIT, 0xFFBEDF78) = 28996148 24228: kaio(AIOWAIT, 0xFFBEDF78) = 28732328 24228: kaio(AIOWAIT, 0xFFBEDF78) = 29027868 24228: kaio(AIOWAIT, 0xFFBEDF78) = 2897200824234: kaio(6, 0x00000000, 0x00000000, 0x00000001, 0xFFBED44C, 0x00000004,
0x00000000) (sleeping...) 24232: kaio(AIOWRITE, 399, 0xA1954000, 8192, 0x727CC000, 0x01BCDBD4) = 0 24232: kaio(AIOWAIT, 0xFFBEDF78) = 29154260 24230: kaio(AIOWRITE, 401, 0x8E714000, 8192, 0x1B120000, 0x01B68CAC) = 0 24230: kaio(AIOWAIT, 0xFFBEDF78) = 28740780 24234: kaio(AIOWRITE, 402, 0xA816A000, 8192, 0x1AFE2000, 0x01AFAD24) = 0 24234: kaio(AIOWRITE, 402, 0xAA084000, 8192, 0x1B00E000, 0x01B984E8) = 0 24234: kaio(AIOWRITE, 390, 0xA9000000, 8192, 0x50822000, 0x01C165A0) = 0 24234: kaio(AIOWAIT, 0xFFBEDF78) = 28935400 24234: kaio(AIOWAIT, 0xFFBEDF78) = 28290340 =====================================================================Mohammed Ahsanuddin
-----Original Message-----
Sent: Tuesday, May 21, 2002 3:23 PM
To: Multiple recipients of list ORACLE-L
Silly question maybe, but have you verified that those kaio call are succeeding?
Their mere appearance in the truss output only verifies async is being attempted.
If the kaio calls fail, they fall back on standard io calls.
Since you're on solaris, pick up Adrian Cockroft's Sun tuning book, you
will find
it invaluable.
Jared
Mohammed.Ahsanuddin_at_VerizonWireless.com
Sent by: root_at_fatcity.com
05/21/2002 09:13 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
cc:
Subject: init.ora params for quick i/0
Hello,
We have implemented quick i/o on a sun server running solaris 8 and Oracle
8173. I have set disk_asynch to true. I have verified using truss that
dbwr
is making kaio calls. Is there anything I am missing on the db side to
make
proper use of quick i/o ?
Also, I am noticing heavy I/O related waits for a process (db file
sequential read, db file parallel write etc..) and would like to involve
our
sys admin in tuning this particular process..If anyone has any idea what I
can specifically ask the sys admin to look at, please do let me know..
I really appreciate any feedback I could get..
Thanks
Mohammed Ahsanuddin
Oracle DBA
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: Mohammed.Ahsanuddin_at_VerizonWireless.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: Jared.Still_at_radisys.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: Jared.Still_at_radisys.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue May 21 2002 - 18:53:30 CDT
 |
 |