Oracle-L: Re: init.ora params for quick i/0

From: <Jared.Still_at_radisys.com>
Date: Tue, 21 May 2002 11:22:49 -0800
Message-ID: <F001.00466547.20020521112249@fatcity.com>

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
--------------------------------------------------------------------