OracleSQLtrace不同level的区别 - 数据库编程

path read' ela= 2238 file number=4 first dba=9218 block cnt=62 obj#=77141 tim=1365214778563809 WAIT #47769055467368: nam='direct path read' ela= 116 file number=4 first dba=9280 block cnt=64 obj#=77141 tim=1365214778564291 WAIT #47769055467368: nam='direct path read' ela= 104 file number=4 first dba=9346 block cnt=62 obj#=77141 tim=1365214778564767 WAIT #47769055467368: nam='direct path read' ela= 88 file number=4 first dba=9408 block cnt=64 obj#=77141 tim=1365214778565239 WAIT #47769055467368: nam='direct path read' ela= 123 file number=4 first dba=9474 block cnt=62 obj#=77141 tim=1365214778565588 WAIT #47769055467368: nam='direct path read' ela= 85 file number=4 first dba=9536 block cnt=64 obj#=77141 tim=1365214778565908 WAIT #47769055467368: nam='direct path read' ela= 111 file number=4 first dba=9602 block cnt=62 obj#=77141 tim=1365214778566363 WAIT #47769055467368: nam='direct path read' ela= 84 file number=4 first dba=9664 block cnt=64 obj#=77141 tim=1365214778566672 WAIT #47769055467368: nam='direct path read' ela= 105 file number=4 first dba=9730 block cnt=62 obj#=77141 tim=1365214778566982 WAIT #47769055467368: nam='direct path read' ela= 86 file number=4 first dba=9792 block cnt=64 obj#=77141 tim=1365214778567389 WAIT #47769055467368: nam='direct path read' ela= 48 file number=4 first dba=9858 block cnt=33 obj#=77141 tim=1365214778567664 FETCH #47769055467368:c=15997,e=16853,p=1033,cr=1035,cu=0,mis=0,r=1,dep=0,og=1,plh=2966233522,tim=1365214778567899 STAT #47769055467368 id=1 cnt=1 pid=0 pos=1 obj=0 op='SORT AGGREGATE (cr=1035 pr=1033 pw=0 time=16849 us)' STAT #47769055467368 id=2 cnt=28027 pid=1 pos=1 obj=77141 op='TABLE ACCESS FULL T (cr=1035 pr=1033 pw=0 time=12512 us cost=290 size=14502 card=2417)' WAIT #47769055467368: nam='SQL*Net message from client' ela= 243 driver id=1650815232 #bytes=1 p3=0 obj#=77141 tim=1365214778568306 FETCH #47769055467368:c=0,e=1,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=0,plh=2966233522,tim=1365214778568341 WAIT #47769055467368: nam='SQL*Net message to client' ela= 2 driver id=1650815232 #bytes=1 p3=0 obj#=77141 tim=1365214778568361 WAIT #47769055467368: nam='SQL*Net message from client' ela= 298 driver id=1650815232 #bytes=1 p3=0 obj#=77141 tim=1365214778568672 PARSE #47769055501464:c=0,e=37,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,plh=0,tim=1365214778568752 WAIT #47769055501464: nam='SQL*Net message to client' ela= 3 driver id=1650815232 #bytes=1 p3=0 obj#=77141 tim=1365214778569032 EXEC #47769055501464:c=0,e=258,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=1,plh=0,tim=1365214778569066

level 12

包括所有等待事件的统计和绑定变量的信息。

PARSING IN CURSOR #47769055380448 len=55 dep=0 uid=0 oct=3 lid=0 tim=1365215140961263 hv=2496234691 ad='843636f8' sqlid='24av8d6acm163'
select sum(object_id) from dexter.t where owner=:oname
END OF STMT
PARSE #47769055380448:c=2999,e=1855,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=1,plh=0,tim=1365215140961260
BINDS #47769055380448:
 Bind#0
  oacdty=01 mxl=2000(400) mxlc=00 mal=00 scl=00 pre=00
  oacflg=03 fl2=1000000 frm=01 csi=852 siz=2000 off=0
  kxsbbbfp=2b72199594b0  bln=2000  avl=03  flg=05
  value="SYS"
EXEC #47769055380448:c=3000,e=3793,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=1,plh=2966233522,tim=1365215140965285
WAIT #47769055380448: nam='SQL*Net message to client' ela= 16 driver

OracleSQLtrace不同level的区别(四)

level 12