暂无图片
Autoallocate and PX
最近更新:2022-03-11 14:21:05

下面是一组从跟踪文件中看到的奇怪的结果。首先,跟踪事件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
......