Had this problem once, caused by a disagreement between me and the
sys-admin of how many physical volumes were needed per number of
disks/controllers we had. I wanted 4 physical volumes, he insisted on
2, and that's what I got. The errors appeared the first day of
production. Why? Because I had no ability to isolate sequential vs.
random reads, or high r/w from low r/w. Everything was glommed between
two physical volumes, including redo, archive, system, rollback.
Winnie_Liu_at_infonet.com wrote:
>
> 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:
>
> 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
> 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: Winnie_Liu_at_infonet.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
Received on Mon Dec 04 2000 - 20:43:03 CST
