My 10046 trace on 10g , time unit of measure is ...?
419915Oct 12 2006 — edited Oct 12 2006Hi,
Here is my 10046 trace of
select count(*) from dict
=====================
PARSING IN CURSOR #1 len=25 dep=0 uid=0 oct=3 lid=0 tim=1133465920541581 hv=2674707624 ad='9ae71014'
select count(*) from dict
END OF STMT
PARSE #1:c=0,e=2385,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=1133465920541573
BINDS #1:
EXEC #1:c=0,e=342,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=1133465920542042
WAIT #1: nam='SQL*Net message to client' ela= 3 p1=1650815232 p2=1 p3=0
FETCH #1:c=40000,e=36229,p=0,cr=564,cu=0,mis=0,r=1,dep=0,og=1,tim=1133465920578386
WAIT #1: nam='SQL*Net message from client' ela= 490 p1=1650815232 p2=1 p3=0
FETCH #1:c=0,e=2,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=0,tim=1133465920579867
WAIT #1: nam='SQL*Net message to client' ela= 2 p1=1650815232 p2=1 p3=0
WAIT #1: nam='SQL*Net message from client' ela= 551079 p1=1650815232 p2=1 p3=0
XCTEND rlbk=0, rd_only=1
STAT #1 id=1 cnt=1 pid=0 pos=1 obj=0 op='SORT AGGREGATE (cr=564 pr=0 pw=0 time=36325 us)'
STAT #1 id=2 cnt=1645 pid=1 pos=1 obj=0 op='VIEW (cr=564 pr=0 pw=0 time=30226 us)'
Notice this line:
STAT #1 id=2 cnt=1645 pid=1 pos=1 obj=0 op='VIEW (cr=564 pr=0 pw=0 time=30226 us)'
Notice the time k-v pair?
time=30226 us
means what?
30226 microseconds of user time?
-jd