Re: Asynch IO and truss question

Hi !

There is an undocumented event (i think it is 10351) which will trace all AIO calls in Solaris. If you set it to level 2 that will trace all AIO errors .

Have a play with it.. !

Best Regards,
K Gopalakrishnan,
Bangalore, INDIA

• Original Message ----- From: paquette stephane <stephane_paquette_at_yahoo.com> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Friday, December 08, 2000 8:59 AM 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_at_yahoo.com
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Shopping - Thousands of Stores. Millions of Products.
> http://shopping.yahoo.com/
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: =?iso-8859-1?q?paquette=20stephane?=
> INET: stephane_paquette_at_yahoo.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).