Message-Id: <10703.123941@fatcity.com> From: =?iso-8859-1?q?paquette=20stephane?= Date: Thu, 7 Dec 2000 08:20:28 -0800 (PST) Subject: Asynch IO and truss question 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@yahoo.com __________________________________________________ Do You Yahoo!? Yahoo! Shopping - Thousands of Stores. Millions of Products.