Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: init.ora params for quick i/0

RE: init.ora params for quick i/0

From: <Mohammed.Ahsanuddin_at_VerizonWireless.com>
Date: Tue, 21 May 2002 13:29:20 -0800
Message-ID: <F001.00466B14.20020521132920@fatcity.com>


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)                       = 28972008
24234:  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
Oracle DBA
Verizon Wireless
Work : 845 365 7203
Pager : 800 366 2337 pin : 16040

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

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). Received on Tue May 21 2002 - 16:29:20 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US