Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Problems with ASYNC-IO
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