下面是一组从跟踪文件中看到的奇怪的结果。首先,跟踪事件10391设置为level 64。这将显示一个对象在并行表扫描时,被打散为细粒度的方式。我列出了前几个粒度:
Distributors associated to that generator:
dist:0 nbgra:52 nid:65535 nbslv:4 size:5131
filedist:0 filno:0 nbgra:0
filedist:1 filno:6 nbgra:52
gnum:0 sz:99 pnum:1048576 rid:(file:6 blk:12..130)
gnum:1 sz:99 pnum:1048576 rid:(file:6 blk:131..235)
gnum:2 sz:99 pnum:1048576 rid:(file:6 blk:236..341)
gnum:3 sz:99 pnum:1048576 rid:(file:6 blk:342..446)
现在,只需稍加处理,对处理第一个粒度的并行处理的进程,施加level 8的10046跟踪。你可以从参数名中认出这是一个10g的跟踪文件。尤其要注意块被访问的顺序:
WAIT #1: nam='PX Deq: Execution Msg' ela= 24415 sleeptime/senderid=268566527 passes=1 p3=0 obj#=-1 tim=1730298979
WAIT #1: nam='direct path read' ela= 18913 file number=6 first dba= 12 block cnt= 5 obj#=59196 tim=1730318924
WAIT #1: nam='direct path read' ela= 5431 file number=6 first dba= 37 block cnt= 4 obj#=59196 tim=1730324753
WAIT #1: nam='direct path read' ela= 5017 file number=6 first dba= 49 block cnt= 8 obj#=59196 tim=1730330528
WAIT #1: nam='direct path read' ela= 6651 file number=6 first dba= 82 block cnt= 7 obj#=59196 tim=1730338312
WAIT #1: nam='direct path read' ela= 5033 file number=6 first dba= 97 block cnt= 8 obj#=59196 tim=1730343998
WAIT #1: nam='direct path read' ela= 2711 file number=6 first dba=114 block cnt= 7 obj#=59196 tim=1730348009
WAIT #1: nam='direct path read' ela= 8746 file number=6 first dba=129 block cnt= 2 obj#=59196 tim=1730357846
WAIT #1: nam='direct path read' ela= 66938 file number=6 first dba= 69 block cnt=12 obj#=59196 tim=1730425271