when i enbale 10046 tracing event,then in the dump file...i got the below information....
i want to know in the first line i.e
what is len,dep,uid,oct,lid,tim
and what is ela (is it elapsed),c,e,p,cr,cu,mis etc.
i know the meaning of sql net message to or from client....
but how would i know at what time DB get a data or at what time user get a data from the DB......
above are some of the queries whick i am looking for.....
PARSING IN CURSOR #7 len=73 dep=0 uid=27 oct=3 lid=27 tim=618157870 hv=1879765364 ad='3f0b34c8'
select sum(returnamt) as amt from cancellationhdr where reqid = 'R222729'
END OF STMT
PARSE #7:c=0,e=727,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=618157865
WAIT #7: nam='SQL*Net message to client' ela= 3 p1=1297371904 p2=1 p3=0
WAIT #0: nam='SQL*Net message from client' ela= 2 p1=1297371904 p2=1 p3=0
WAIT #7: nam='SQL*Net message to client' ela= 1 p1=1297371904 p2=1 p3=0
WAIT #0: nam='SQL*Net message from client' ela= 2 p1=1297371904 p2=1 p3=0
BINDS #7:
XCTEND rlbk=0, rd_only=1
EXEC #7:c=0,e=113,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=618158815
WAIT #7: nam='SQL*Net message to client' ela= 2 p1=1297371904 p2=1 p3=0
WAIT #0: nam='SQL*Net message from client' ela= 2 p1=1297371904 p2=1 p3=0
WAIT #7: nam='SQL*Net message to client' ela= 2 p1=1297371904 p2=1 p3=0
FETCH #7:c=0,e=49,p=0,cr=2,cu=0,mis=0,r=1,dep=0,og=4,tim=618159398
WAIT #0: nam='SQL*Net message from client' ela= 2 p1=1297371904 p2=1 p3=0
STAT #7 id=1 cnt=1 pid=0 pos=1 obj=0 op='SORT AGGREGATE '
STAT #7 id=2 cnt=0 pid=1 pos=1 obj=7421 op='TABLE ACCESS BY INDEX ROWID CANCELLATIONHDR '
STAT #7 id=3 cnt=0 pid=2 pos=1 obj=7425 op='INDEX RANGE SCAN CANCELLATIONDHRREQID '
WAIT #7: nam='SQL*Net message to client' ela= 1 p1=1297371904 p2=1 p3=0
WAIT #0: nam='SQL*Net message from client' ela= 1 p1=1297371904 p2=1 p3=0
STAT #5 id=1 cnt=1 pid=0 pos=1 obj=0 op='SORT AGGREGATE '
STAT #5 id=2 cnt=1 pid=1 pos=1 obj=7504 op='TABLE ACCESS BY INDEX ROWID MONEYRECIEPT '
STAT #5 id=3 cnt=1 pid=2 pos=1 obj=7506 op='INDEX RANGE SCAN MOENEYRECEIPTID '
WAIT #5: nam='SQL*Net message to client' ela= 1 p1=1297371904 p2=1 p3=0
WAIT #0: nam='SQL*Net message from client' ela= 2 p1=1297371904 p2=1 p3=0
WAIT #5: nam='SQL*Net message to client' ela= 2 p1=1297371904 p2=1 p3=0
WAIT #0: nam='SQL*Net message from client' ela= 2 p1=1297371904 p2=1 p3=0