Barbara, I know how distracted you were with all the jokes being tossed about, but really...
It looks to me (with just this snippet of trace) that the cursor #3 did some communication and then waited for 10 seconds for a response. Without seeing the raw trace file and sequence of events, this is my best guess. Daniel Barbara Baker wrote: > Daniel: > Does this mean I was supposed to be paying attention > in class?? > > Here's everything I can find associated with sql*net > message from client in that cursor. Can't figure out > from this how it came up with 10.73 (although that one > wait matches up with the max wait of 10.71) > > Am I being really dense? > WAIT!! don't answer that! > > WAIT #3: nam='SQL*Net message from client' ela= 0 > p1=1413697536 p2=1 p3=0 > WAIT #3: nam='SQL*Net message from client' ela= 0 > p1=1413697536 p2=1 p3=0 > WAIT #3: nam='SQL*Net message from client' ela= 1 wait_time = 1 centisecond > > p1=1413697536 p2=1 p3=0 > WAIT #3: nam='SQL*Net message from client' ela= 0 > p1=1413697536 p2=1 p3=0 > WAIT #3: nam='SQL*Net message from client' ela= 0 > p1=1413697536 p2=1 p3=0 > WAIT #3: nam='SQL*Net message from client' ela= 0 > p1=1413697536 p2=1 p3=0 > WAIT #3: nam='SQL*Net message from client' ela= 1 wait_time = wait_time (1 cs) + 1 cs = 2 cs > > p1=1413697536 p2=1 p3=0 > WAIT #3: nam='SQL*Net message from client' ela= 1071 > p1=1413697536 p2=1 p3=0 wait_time = wait_time(2 cs) + 1071 cs = 1073 cs -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Fink INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (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).
