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

T (cr=1035 pr=1033 pw=0 time=15880 us cost=290 size=14502 card=2417)' FETCH #47769055467368:c=0,e=4,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=0,plh=2966233522,tim=1365214772690621 PARSE #47769055501464:c=0,e=240,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,plh=0,tim=1365214772692158 BINDS #47769055501464: Bind#0 oacdty=123 mxl=4000(4000) mxlc=00 mal=00 scl=00 pre=00 oacflg=00 fl2=1000000 frm=00 csi=00 siz=4000 off=0 toid ptr value=87B716C0 length=16 AD26DE2F1F4C7C06E0431E4EE50AB7B3 kxsbbbfp=2b72199588c8 bln=4000 avl=00 flg=15 Bind#1 oacdty=02 mxl=22(22) mxlc=00 mal=00 scl=00 pre=00 oacflg=01 fl2=1000000 frm=00 csi=00 siz=24 off=0 kxsbbbfp=2b7219959c68 bln=22 avl=22 flg=05 value=### An invalid number has been seen.Memory contents are : Dump of memory from 0x00002B7219959C68 to 0x00002B7219959C7E 2B7219959C60 000010C1 00000000 [........] 2B7219959C70 00000000 00000000 00000000 00000000 [................] EXEC #47769055501464:c=2000,e=1550,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=1,plh=0,tim=1365214772693876

evel 8

包括等待时间的信息，但是不包括绑定变量的信息

PARSING IN CURSOR #47769055467368 len=49 dep=0 uid=0 oct=3 lid=0 tim=1365214778550346 hv=1571021352 ad='861fc700' sqlid='fk8k4v1fu7sj8'
select count(*) from dexter.t where owner=:oname
END OF STMT
PARSE #47769055467368:c=0,e=213,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,plh=2966233522,tim=1365214778550343
EXEC #47769055467368:c=0,e=88,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,plh=2966233522,tim=1365214778550849
WAIT #47769055467368: nam='SQL*Net message to client' ela= 12 driver id=1650815232 #bytes=1 p3=0 obj#=77141 tim=13652147




78550986
WAIT #47769055467368: nam='direct path read' ela= 144 file number=4 first dba=523 block cnt=13 obj#=77141 tim=1365214778551487
WAIT #47769055467368: nam='direct path read' ela= 567 file number=4 first dba=537 block cnt=15 obj#=77141 tim=1365214778552290
WAIT #47769055467368: nam='direct path read' ela= 71 file number=4 first dba=553 block cnt=15 obj#=77141 tim=1365214778552590
WAIT #47769055467368: nam='direct path read' ela= 75 file number=4 first dba=569 block cnt=15 obj#=77141 tim=1365214778552969
WAIT #47769055467368: nam='direct path read' ela= 76 file number=4 first dba=585 block cnt=15 obj#=77141 tim=1365214778553554
WAIT #47769055467368: nam='direct path read' ela= 162 file number=4 first dba=601 block cnt=15 obj#=77141 tim=1365214778553924
WAIT #47769055467368: nam='direct path read' ela= 89 file number=4 first dba=617 block cnt=15 obj#=77141 tim=1365214778554252
WAIT #47769055467368: nam='direct path read' ela= 53 file number=4 first dba=633 block cnt=7 obj#=77141 tim=1365214778555146
WAIT #47769055467368: nam='direct path read' ela= 57 file number=4 first dba=8832 block cnt=8 obj#=77141 tim=1365214778555479
WAIT #47769055467368: nam='direct path read' ela= 1622 file number=4 first dba=8962 block cnt=62 obj#=77141 tim=1365214778557242
WAIT #47769055467368: nam='direct path read' ela= 405 file number=4 first dba=9024 block cnt=64 obj#=77141 tim=1365214778558052
WAIT #47769055467368: nam='direct path read' ela= 287 file number=4 first dba=9090 block cnt=62 obj#=77141 tim=1365214778559326
WAIT #47769055467368: nam='direct path read' ela= 504 file number=4 first dba=9152 block cnt=64 obj#=77141 tim=1365214778560717
WAIT #47769055467368: nam='direct

OracleSQLtrace不同level的区别(二)

evel 8