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

Home -> Community -> Usenet -> c.d.o.server -> Problems with ASYNC-IO

Problems with ASYNC-IO

From: Torsten Borchert <T.Borchert_at_DeutschePost.de>
Date: Tue, 30 Jun 1998 10:18:16 +0200
Message-ID: <35989F48.C75D88D8@DeutschePost.de>


In the oracle-alert I found a lot of messages like this:

SFAIO:Failed to issue async i/o (Error #11). Attemping sync i/o. Sat Jun 27 13:27:38 1998
SFAIO:Failed to issue async i/o (Error #11). Attemping sync i/o. SFAIO:Failed to issue async i/o (Error #11). Attemping sync i/o. Sat Jun 27 13:27:50 1998
Thread 1 advanced to log sequence 1635
  Current log# 3 seq# 1635 mem# 0: /dev/vd/rvdisk142 Sat Jun 27 13:27:51 1998
SFAIO:Failed to issue async i/o (Error #11). Attemping sync i/o. SFAIO:Failed to issue async i/o (Error #11). Attemping sync i/o.

We are running a SINIX - Release: SINIX-Y 5.43 B1001 RM600 4/1024 R4000 Database is on striped raw devices (via SINIX - LVM), each 'datafile' is striped over 14 physical devices with a stripe factor of 32 kByte. Related init-ora-parameters are:

db_block_size				= 8192
use_async_io                            = TRUE                          
use_list_io_extension                   = TRUE                          
use_readv                               = TRUE
use_positional_io                       = TRUE

Oracle-Release is:

Oracle7 Server Release 7.3.2.3.0 - Production Release With the distributed and parallel query options PL/SQL Release 2.3.2.3.0 - Production

This occurs when we are runnining large batches and/or a online backup is in progress.

Who can me say:
-what does't means
-which additional resources exist to tune database or operating system

Thank you

Torsten Received on Tue Jun 30 1998 - 03:18:16 CDT

Original text of this message

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