OracleSQLtrace不同level的区别(五)

2014-11-24 16:55:56 · 作者: · 浏览: 9
id=1650815232 #bytes=1 p3=0 obj#=77141 tim=1365215140965453 WAIT #47769055380448: nam='asynch descriptor resize' ela= 10 outstanding #aio=0 current aio limit=152 new aio limit=182 obj#=77141 tim=1365215140965882 WAIT #47769055380448: nam='direct path read' ela= 227 file number=4 first dba=523 block cnt=13 obj#=77141 tim=1365215140966341 WAIT #47769055380448: nam='direct path read' ela= 474 file number=4 first dba=537 block cnt=15 obj#=77141 tim=1365215140967633 WAIT #47769055380448: nam='direct path read' ela= 164 file number=4 first dba=553 block cnt=15 obj#=77141 tim=1365215140968680 WAIT #47769055380448: nam='direct path read' ela= 508 file number=4 first dba=569 block cnt=15 obj#=77141 tim=1365215140969663 WAIT #47769055380448: nam='direct path read' ela= 478 file number=4 first dba=585 block cnt=15 obj#=77141 tim=1365215140970818 WAIT #47769055380448: nam='direct path read' ela= 176 file number=4 first dba=601 block cnt=15 obj#=77141 tim=1365215140971762 WAIT #47769055380448: nam='direct path read' ela= 75 file number=4 first dba=617 block cnt=15 obj#=77141 tim=1365215140972313 WAIT #47769055380448: nam='direct path read' ela= 47 file number=4 first dba=633 block cnt=7 obj#=77141 tim=1365215140973455 WAIT #47769055380448: nam='direct path read' ela= 62 file number=4 first dba=8832 block cnt=8 obj#=77141 tim=1365215140974061 WAIT #47769055380448: nam='direct path read' ela= 1412 file number=4 first dba=8962 block cnt=62 obj#=77141 tim=1365215140975874 WAIT #47769055380448: nam='direct path read' ela= 568 file number=4 first dba=9024 block cnt=64 obj#=77141 tim=1365215140976990 WAIT #47769055380448: nam='direct path read' ela= 566 fil
e number=4 first dba=9090 block cnt=62 obj#=77141 tim=1365215140979413 WAIT #47769055380448: nam='direct path read' ela= 463 file number=4 first dba=9152 block cnt=64 obj#=77141 tim=1365215140981749 WAIT #47769055380448: nam='direct path read' ela= 597 file number=4 first dba=9218 block cnt=62 obj#=77141 tim=1365215140984267 WAIT #47769055380448: nam='direct path read' ela= 419 file number=4 first dba=9280 block cnt=64 obj#=77141 tim=1365215140986349 WAIT #47769055380448: nam='direct path read' ela= 268 file number=4 first dba=9346 block cnt=62 obj#=77141 tim=1365215140988105 WAIT #47769055380448: nam='direct path read' ela= 589 file number=4 first dba=9408 block cnt=64 obj#=77141 tim=1365215140990125 WAIT #47769055380448: nam='direct path read' ela= 311 file number=4 first dba=9474 block cnt=62 obj#=77141 tim=1365215140991845 WAIT #47769055380448: nam='direct path read' ela= 392 file number=4 first dba=9536 block cnt=64 obj#=77141 tim=1365215140993754 WAIT #47769055380448: nam='direct path read' ela= 450 file number=4 first dba=9602 block cnt=62 obj#=77141 tim=1365215140995500 WAIT #47769055380448: nam='direct path read' ela= 526 file number=4 first dba=9664 block cnt=64 obj#=77141 tim=1365215140997729 WAIT #47769055380448: nam='direct path read' ela= 97 file number=4 first dba=9730 block cnt=62 obj#=77141 tim=1365215140998471 WAIT #47769055380448: nam='direct path read' ela= 141 file number=4 first dba=9792 block cnt=64 obj#=77141 tim=1365215140998813 WAIT #47769055380448: nam='direct path read' ela= 108 file number=4 first dba=9858 block cnt=33 obj#=77141 tim=1365215140999155 FETCH #47769055380448:c=33995,e=33888,p=1033,cr=1035,cu=0,mi