- 论坛徽章:
- 0
|
如题,在create mv log on table时产生大量的wait for table lock,查看trace文件上报
bind 3: dty=1 mxl=128(46) mal=00 scl=00 pre=00 oacflg=18 oacfl2=1 size=128 offset=0
bfp=70000050e6340f0 bln=128 avl=46 flg=09
value="snapshot log for master table HLR.C_SUB_COMMON"
WAIT #13: nam='db file sequential read' ela= 5759 p1=1 p2=11314 p3=1
WAIT #13: nam='db file sequential read' ela= 3242 p1=1 p2=325 p3=1
WAIT #13: nam='db file sequential read' ela= 5633 p1=1 p2=4746 p3=1
EXEC #13:c=0,e=15283,p=3,cr=1,cu=3,mis=0,r=1,dep=2,og=4,tim=3459835055612
EXEC #2:c=0,e=22061,p=4,cr=42,cu=3,mis=0,r=0,dep=1,og=4,tim=3459835055712
WAIT #1: nam='Wait for Table Lock' ela= 976576 p1=0 p2=0 p3=0
WAIT #1: nam='Wait for Table Lock' ela= 976575 p1=0 p2=0 p3=0
WAIT #1: nam='Wait for Table Lock' ela= 976580 p1=0 p2=0 p3=0
........
如上 |
|