Re: Again - TRACE - What does Out of async requests mean?

From: <Winnie_Liu_at_infonet.com>
Date: Mon, 4 Dec 2000 15:31:29 -0800
Message-Id: <10700.123597@fatcity.com>

Cherie,

I did a search in Metalink and came up with a forum talking about the exact same error that you got in your udump directory.

Here is the direct quote from Oracle support:

"In Oracle7 there is a "hardcoded" limit on I/O requests at 200. The message is a warning, not an error, and no I/O's are lost. While the maximum number of async I/O requests is outstanding, further requests are handled
synchronously. The impact on performance is unknown, but since the majority of requests will still be done
asynchronously, it is expected to be minimal. Tuning I/O (striping, spreading across more devices) may help to releave the bottleneck. "

HTH Winnie

Cherie_Machler_at_gelco.com_at_fatcity.com on 12/04/2000 01:56:26 PM

Please respond to ORACLE-L_at_fatcity.com

Sent by: root_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc:

Subject: Again - TRACE - What does Out of async requests mean?

Since I didn't get a response the first time, I'm submitting it one more time in the hopes that someone might get a fresh look at it:

I have the following trace files in my udump directory. They all say the same thing. The database is 7.3.4 on UNIX Sun Solaris 2.6.

This database supports a web logic application.

Can anyone explain to me in layman's terms what the error 'Out of async requests' means:

Thanks,

Cherie
Cherie Machler
Gelco Information Network

Dump file /orasoft/oracle/admin/EXTPRD01/udump/extprd01_ora_18215.trc Oracle7 Server Release 7.3.4.4.0 - Production With the distributed and parallel query options PL/SQL Release 2.3.4.4.0 - Production
ORACLE_HOME = /orasoft/oracle/product/7.3.4 System name: SunOS

Node name:      mspwww01
Release:        5.6
Version:        Generic_105181-20
Machine:        sun4u

Instance name: EXTPRD01
Redo thread mounted by this instance: 1
Oracle process number: 255
Unix process pid: 18215, image: oracleEXTPRD01

2000.11.15.14.56.44.000
SESSION ID:(598.13537) 2000.11.15.14.56.44.000 Out of async requests. Out of async requests. Out of async requests. Out of async requests. Out of async requests. Out of async requests.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author:
INET: Cherie_Machler_at_gelco.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: Cherie_Machler_at_gelco.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