| 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
As suggested by Frank, turning on Cached option of Quick I/O really helped
the reads (at the same time with some negative impact on writes). At this
point I have enabled cache quick i/o on data file systems. This is on a sun
e10k with 28 cpu and 28g ram.
If anyone who has used cached quick i/o can comment if there are any pros/cons of using this option, would be great.
Thanks
Mohammed Ahsanuddin
Oracle DBA
-----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). Received on Thu May 23 2002 - 12:51:46 CDT
 |
 |