<html><DIV>
<P>one more thing i forgot is check the stats using qiostat on that particular file </P>
<P>if it shows stats if it is showing 0 then it is not enabled </P>
<P>this is incremental there is a command to reset this but i have forgotten i will let u know </P>
<P>fox$qiostat LOG5BLINK_01.ORA<BR> OPERATIONS FILE BLOCKS AVG TIME(ms)</P>
<P>FILE NAME READ WRITE READ WRITE READ WRITE</P>
<P>LOG5BLINK_01.ORA 73036 252987 4669500 4669462 1.3 5.6</P>
<P><BR><BR> </P></DIV>
<DIV></DIV>
<DIV></DIV>>From: paquette stephane <STEPHANE_PAQUETTE_at_YAHOO.COM>
<DIV></DIV>>Reply-To: ORACLE-L_at_fatcity.com
<DIV></DIV>>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_FATCITY.COM>
<DIV></DIV>>Subject: Asynch IO and truss question
<DIV></DIV>>Date: Thu, 07 Dec 2000 19:29:44 -0800
<DIV></DIV>>
<DIV></DIV>>Hi all,
<DIV></DIV>>
<DIV></DIV>>Since the sys admin is available 15min per week, I've
<DIV></DIV>>started to play with truss to make sure asynch IO was
<DIV></DIV>>done.
<DIV></DIV>>This is on Solaris 2.7, Oracle 8.1.6 and Veritas Quick
<DIV></DIV>>IO.
<DIV></DIV>>I've done truss -fl on the the dbwr process.
<DIV></DIV>>It's giving me
<DIV></DIV>>28529/1: Received signal #14, SIGALRM, in
<DIV></DIV>>semop() [caught]
<DIV></DIV>>28529/1: semop(37224452, 0xFFFFFFFF7FFFDCAC, 1)
<DIV></DIV>> Err#91 ERESTART
<DIV></DIV>>28529/1: sigprocmask(SIG_BLOCK,
<DIV></DIV>>0xFFFFFFFF7FFFD770, 0x00000000) = 0
<DIV></DIV>>28529/1: times(0xFFFFFFFF7FFFD6A0)
<DIV></DIV>> = 243599308
<DIV></DIV>>28529/1: sigprocmask(SIG_UNBLOCK,
<DIV></DIV>>0xFFFFFFFF7FFFD770, 0x00000000) = 0
<DIV></DIV>>28529/1: getcontext(0xFFFFFFFF7FFFD3C0)
<DIV></DIV>>28529/1: setcontext(0xFFFFFFFF7FFFD3C0)
<DIV></DIV>>28529/1: sigprocmask(SIG_BLOCK,
<DIV></DIV>>0xFFFFFFFF7FFFDAE0, 0x00000000) = 0
<DIV></DIV>>28529/1: setitimer(ITIMER_REAL,
<DIV></DIV>>0xFFFFFFFF7FFFD9B0, 0x00000000) = 0
<DIV></DIV>>28529/1: sigprocmask(SIG_UNBLOCK,
<DIV></DIV>>0xFFFFFFFF7FFFDAB0, 0x00000000) = 0
<DIV></DIV>>28529/1: kaio(AIOWRITE, 402, 0x381C8C000,
<DIV></DIV>>16384, 0x0342000001E92B70) Err#48 ENOTSUP
<DIV></DIV>>28529/1: lwp_cond_signal(0xFFFFFFFF7C8EBF70)
<DIV></DIV>> = 0
<DIV></DIV>>28529/140: lwp_cond_wait(0xFFFFFFFF7C8EBF70,
<DIV></DIV>>0xFFFFFFFF7C8EBF80, 0x00000000) = 0
<DIV></DIV>>28529/140: pwrite(402, "0202\0\0\080\r\b\00E
<DIV></DIV>>}1A".., 16384, 0x03420000) = 16384
<DIV></DIV>>28529/1: kaio(AIOWAIT, 0xFFFFFFFF7FFFD710)
<DIV></DIV>> = 1
<DIV></DIV>>28529/140: kaio(AIONOTIFY, -2184159392)
<DIV></DIV>> = 0
<DIV></DIV>>28529/1: getcontext(0xFFFFFFFF7FFFD8D0)
<DIV></DIV>>28529/1: sigprocmask(SIG_BLOCK,
<DIV></DIV>>0xFFFFFFFF7FFFDAE0, 0x00000000) = 0
<DIV></DIV>>28529/1: times(0xFFFFFFFF7FFFD9B0)
<DIV></DIV>> = 243599310
<DIV></DIV>>28529/1: setitimer(ITIMER_REAL,
<DIV></DIV>>0xFFFFFFFF7FFFD9B0, 0x00000000) = 0
<DIV></DIV>>28529/1: sigprocmask(SIG_UNBLOCK,
<DIV></DIV>>0xFFFFFFFF7FFFDA80, 0x00000000) = 0
<DIV></DIV>>28529/1: semop(37224452, 0xFFFFFFFF7FFFDCAC, 1)
<DIV></DIV>>(sleeping...)
<DIV></DIV>>28529/2: kaio(6, 0x00000000, 0x00000000,
<DIV></DIV>>0x00000000, 0x00000000, 0x00000000) (sleeping...)
<DIV></DIV>>28529/3: lwp_cond_wait(0xFFFFFFFF7D58DF70,
<DIV></DIV>>0xFFFFFFFF7D58DF80, 0x00000000) (sleeping...)
<DIV></DIV>>28529/4: lwp_cond_wait(0xFFFFFFFF7D57BF70,
<DIV></DIV>>0xFFFFFFFF7D57BF80, 0x00000000) (sleeping...)
<DIV></DIV>>...
<DIV></DIV>>
<DIV></DIV>>I've read on metalink that the error 48 is because of
<DIV></DIV>>the vol_maxio buffer being smaller than
<DIV></DIV>>db_file_direct_io_count*db_block_size.
<DIV></DIV>>Anybody can confirm ?
<DIV></DIV>>
<DIV></DIV>>Also, should I be concerned with the 91 error ?
<DIV></DIV>>
<DIV></DIV>>TIA
<DIV></DIV>>
<DIV></DIV>>
<DIV></DIV>>=====
<DIV></DIV>>Stephane Paquette
<DIV></DIV>>DBA Oracle
<DIV></DIV>>stephane_paquette_at_yahoo.com
<DIV></DIV>>
<DIV></DIV>>__________________________________________________
<DIV></DIV>>Do You Yahoo!?
<DIV></DIV>>Yahoo! Shopping - Thousands of Stores. Millions of Products.
<DIV></DIV>>http://shopping.yahoo.com/
<DIV></DIV>>--
<DIV></DIV>>Please see the official ORACLE-L FAQ: http://www.orafaq.com
<DIV></DIV>>--
<DIV></DIV>>Author: =?iso-8859-1?q?paquette=20stephane?=
<DIV></DIV>> INET: stephane_paquette_at_yahoo.com
<DIV></DIV>>
<DIV></DIV>>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
<DIV></DIV>>San Diego, California -- Public Internet access / Mailing Lists
<DIV></DIV>>--------------------------------------------------------------------
<DIV></DIV>>To REMOVE yourself from this mailing list, send an E-Mail message
<DIV></DIV>>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
<DIV></DIV>>the message BODY, include a line containing: UNSUB ORACLE-L
<DIV></DIV>>(or the name of mailing list you want to be removed from). You may
<DIV></DIV>>also send the HELP command for other information (like subscribing).
<DIV></DIV><br clear=all><hr>Get more from the Web. FREE MSN Explorer download : http://explorer.msn.com<br></p></html>
Received on Fri Dec 08 2000 - 16:30:55 CST
