Asynch IO and truss question

From: paquette stephane <stephane_paquette_at_yahoo.com>
Date: Thu, 7 Dec 2000 08:20:28 -0800 (PST)
Message-Id: <10703.123941@fatcity.com>

Hi all,

Since the sys admin is available 15min per week, I've started to play with truss to make sure asynch IO was done.
This is on Solaris 2.7, Oracle 8.1.6 and Veritas Quick IO.
I've done truss -fl on the the dbwr process. It's giving me
28529/1: Received signal #14, SIGALRM, in semop() [caught]

28529/1:        semop(37224452, 0xFFFFFFFF7FFFDCAC, 1)
         Err#91 ERESTART
28529/1:        sigprocmask(SIG_BLOCK,
0xFFFFFFFF7FFFD770, 0x00000000) = 0
28529/1:        times(0xFFFFFFFF7FFFD6A0)             


         = 243599308

28529/1:        sigprocmask(SIG_UNBLOCK,
0xFFFFFFFF7FFFD770, 0x00000000) = 0
28529/1:        getcontext(0xFFFFFFFF7FFFD3C0)
28529/1:        setcontext(0xFFFFFFFF7FFFD3C0)
28529/1:        sigprocmask(SIG_BLOCK,
0xFFFFFFFF7FFFDAE0, 0x00000000) = 0
28529/1:        setitimer(ITIMER_REAL,
0xFFFFFFFF7FFFD9B0, 0x00000000) = 0
28529/1:        sigprocmask(SIG_UNBLOCK,
0xFFFFFFFF7FFFDAB0, 0x00000000) = 0
28529/1:        kaio(AIOWRITE, 402, 0x381C8C000,
16384, 0x0342000001E92B70) Err#48 ENOTSUP
28529/1:        lwp_cond_signal(0xFFFFFFFF7C8EBF70)   


         = 0

28529/140:      lwp_cond_wait(0xFFFFFFFF7C8EBF70,
0xFFFFFFFF7C8EBF80, 0x00000000) = 0
28529/140:      pwrite(402, "0202\0\0\080\r\b\00E
}1A".., 16384, 0x03420000) = 16384
28529/1:        kaio(AIOWAIT, 0xFFFFFFFF7FFFD710)     


         = 1

28529/140:      kaio(AIONOTIFY, -2184159392)          


         = 0

28529/1:        getcontext(0xFFFFFFFF7FFFD8D0)
28529/1:        sigprocmask(SIG_BLOCK,
0xFFFFFFFF7FFFDAE0, 0x00000000) = 0
28529/1:        times(0xFFFFFFFF7FFFD9B0)             


         = 243599310

28529/1:        setitimer(ITIMER_REAL,
0xFFFFFFFF7FFFD9B0, 0x00000000) = 0
28529/1:        sigprocmask(SIG_UNBLOCK,
0xFFFFFFFF7FFFDA80, 0x00000000) = 0
28529/1:        semop(37224452, 0xFFFFFFFF7FFFDCAC, 1)
(sleeping...)
28529/2:        kaio(6, 0x00000000, 0x00000000,
0x00000000, 0x00000000, 0x00000000) (sleeping...)
28529/3:        lwp_cond_wait(0xFFFFFFFF7D58DF70,
0xFFFFFFFF7D58DF80, 0x00000000) (sleeping...)
28529/4:        lwp_cond_wait(0xFFFFFFFF7D57BF70,

0xFFFFFFFF7D57BF80, 0x00000000) (sleeping...) ...

I've read on metalink that the error 48 is because of the vol_maxio buffer being smaller than
db_file_direct_io_count*db_block_size.
Anybody can confirm ?

Also, should I be concerned with the 91 error ?

TIA

Stephane Paquette
DBA Oracle
stephane_paquette_at_yahoo.com

Do You Yahoo!?
Yahoo! Shopping - Thousands of Stores. Millions of Products. Received on Thu Dec 07 2000 - 10:20:28 CST