RE: Event 10046 trace

From: Hatzistavrou John <John.Hatzistavrou.sema_at_mail.tellas.gr>
Date: Thu, 17 Jun 2004 16:06:23 +0300
Message-ID: <EC77AB8681A2B44B895956EE2A2D10A50C28C3@XCHVSRV01.evergy.local>

According to what I have read, this indicates that you have started the trace in the middle of the transaction.

Yannis Hatzistavrou

-----Original Message-----
From: Madhu Konda [mailto:konda_madhusudhan_at_yahoo.com] Sent: Thursday, June 17, 2004 3:48 PM
To: oracle-l_at_freelists.org
Subject: Event 10046 trace

Hi All,

We are running Oralce 8.1.7. on HP-UX . Recently I traced a application (third party) and I see some the following information in the trace file .

PARSING IN CURSOR #6 len=181 dep=0 uid=8564 oct=6 lid=8564 tim=1314794115 hv=1049137217 ad='712a38b0' UPDATE SIEBEL.S_EVT_ACT SET

      LAST_UPD_BY = :1,
      MODIFICATION_NUM = :2,
      APPT_START_DT = :3,
      LAST_UPD = :4
   WHERE
      ROW_ID = :5 AND MODIFICATION_NUM = :6

END OF STMT

PARSE #6:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=3,tim=1314794115
EXEC #6:c=0,e=1,p=0,cr=4,cu=27,mis=0,r=1,dep=0,og=3,tim=1314794116
WAIT #6: nam='SQL*Net message to client' ela= 0 p1=1413697536 p2=1 p3=0

WAIT #6: nam='SQL*Net message from client' ela= 0 p1=1413697536 p2=1 p3=0

EXEC #9:c=0,e=0,p=0,cr=0,cu=4,mis=0,r=1,dep=0,og=3,tim=1314794116
WAIT #9: nam='SQL*Net message to client' ela= 0 p1=1413697536 p2=1 p3=0
WAIT #9: nam='SQL*Net message from client' ela= 1 p1=1413697536 p2=1

p3=0
XCTEND rlbk=0, rd_onfiltered=0
WAIT #0: nam='log file sync' ela= 0 p1=170 p2=0 p3=0 WAIT #0: nam='SQL*Net message to client' ela= 0 p1=1413697536 p2=1 p3=0 *** 2004-06-10 13:55:28.184
WAIT #0: nam='SQL*Net message from client' ela= 36301 p1=1413697536 p2=1 p3=0

>From the trace output I can see that Parse#6,Fetch#6,WAIT#6 are
attributed to Curosr #6 . But I am not able to figure out what event is invoking the WAIT#9 and WAIT # 0 . Also I am not able to figure out what event is causing this huge wait (363.01 secs) on SQL*Net message from client .

Can somebody please explain me whats going on here.

TIA, Madhu

Do you Yahoo!?
Take Yahoo! Mail with you!
<http://us.rd.yahoo.com/mail/taglines/*http:/mobile.yahoo.com/maildemo> Get it on your mobile phone.

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Thu Jun 17 2004 - 08:04:17 CDT