oracle 最大值加一,关于一次IO的最大值

os  windowsxp

db 10.2.0.4

执行alter session set events '10046 trace name context forever,level 12';

---trace文件

select count(*) from t

END OF STMT

PARSE #1:c=15625,e=999886,p=1149,cr=99,cu=2,mis=1,r=0,dep=0,og=1,tim=19979922257

BINDS #1:

EXEC #1:c=0,e=294,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=1,tim=19979923759

WAIT #1: nam='SQL*Net message to client' ela= 6 driver id=1111838976 #bytes=1 p3=0 obj#=0 tim=19979924030

WAIT #1: nam='db file scattered read' ela= 5707 file#=13 block#=12 blocks=5 obj#=57676 tim=19979930094

WAIT #1: nam='db file scattered read' ela= 1099 file#=13 block#=17 blocks=8 obj#=57676 tim=19979932128

WAIT #1: nam='db file scattered read' ela= 1249 file#=13 block#=26 blocks=7 obj#=57676 tim=19979933980

WAIT #1: nam='db file scattered read' ela= 1506 file#=13 block#=33 blocks=8 obj#=57676 tim=19979935956

WAIT #1: nam='db file scattered read' ela= 891 file#=13 block#=42 blocks=5 obj#=57676 tim=19979937400

为什么我trace出的文件不是这种格式的？

在这p3=128block 表示最大的一次IO

WAIT #26: nam='db file scattered read' ela= 18267 p1=10 p2=10 p3=128

WAIT #26: nam='db file scattered read' ela= 8836 p1=10 p2=138 p3=127

WAIT #26: nam='db file scattered read' ela= 8923 p1=10 p2=265 p3=128

WAIT #26: nam='db file scattered read' ela= 8853 p1=10 p2=393 p3=128

参考url

http://www.eygle.com/archives/20 ... ock_read_count.html