sybase中给表增加和删除字段时内部处理过程分析
分析一下给表增加字段时sybase数据库的内部处理过程。
表原来的结构:
create table t(id int, col1 varchar(30))
向表中插入数据:
insert into t
select 1,'a'
go
insert into t
select 1,'a'
go
insert into t
select 2,'b'
go
insert into t
select 3,'c'
go
测试表t的object_id是:
1> select object_id('t')
2> go
-----------
608002166
利用dbcc log分析数据库的日志,可以看出上面的四条insert语句对应了四个单独的事务。因为sybase中默认是隐式提交的。
四条记录的页号和偏移分别是:
row1. pageno=801 offset=32
row2. pageno=801 offset=44
row3. pageno=801 offset=56
row4. pageno=801 offset=68
BEGINXACT (256007,32) sessionid=256007,32
attcnt=1 rno=32 op=0 padlen=2 sessionid=256007,32 len=64
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
masterxsid=(invalid sessionid)
xstat=XBEG_ENDXACT,
spid=1 suid=1 uid=1 masterdbid=0 dtmcord=0
name=$ins time=Apr 7 2010 10:21:49:756AM
INSERT (256007,33) sessionid=256007,32
attcnt=1 rno=33 op=4 padlen=0 sessionid=256007,32 len=64
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
objid=608002166 ptnid=608002166 pageno=801 offset=32 status=0x800 (0x08
00
(XSTAT_EXPAGE))
cid=0 indid=0
old ts=0x0000 0x000017d3 new ts=0x0000 0x000017e1
xrow:
10003620d3c ( 0): 01000000 0001000c 61020908 ........a...
ENDXACT (256007,34) sessionid=256007,32
attcnt=1 rno=34 op=30 padlen=4 sessionid=256007,32 len=32
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
endstat=COMMIT time=Apr 7 2010 10:21:49:756AM
xstat=0x0 []
BEGINXACT (256007,35) sessionid=256007,35
attcnt=1 rno=35 op=0 padlen=2 sessionid=256007,35 len=64
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
masterxsid=(invalid sessionid)
xstat=XBEG_ENDXACT,
spid=1 suid=1 uid=1 masterdbid=0 dtmcord=0
name=$ins time=Apr 7 2010 10:21:55:756AM
INSERT (256007,36) sessionid=256007,35
attcnt=1 rno=36 op=4 padlen=0 sessionid=256007,35 len=64
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
objid=608002166 ptnid=608002166 pageno=801 offset=44 status=0x800 (0x08
00
(XSTAT_EXPAGE))
cid=0 indid=0
old ts=0x0000 0x000017e1 new ts=0x0000 0x000017e3
xrow:
10003620ddc ( 0): 01010000 0001000c 61020908 ........a...
ENDXACT (256007,37) sessionid=256007,35
attcnt=1 rno=37 op=30 padlen=4 sessionid=256007,35 len=32
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
endstat=COMMIT time=Apr 7 2010 10:21:55:756AM
xstat=0x0 []
BEGINXACT (256007,38) sessionid=256007,38
attcnt=1 rno=38 op=0 padlen=2 sessionid=256007,38 len=64
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
masterxsid=(invalid sessionid)
xstat=XBEG_ENDXACT,
spid=1 suid=1 uid=1 masterdbid=0 dtmcord=0
name=$ins time=Apr 7 2010 10:22:03:756AM
INSERT (256007,39) sessionid=256007,38
attcnt=1 rno=39 op=4 padlen=0 sessionid=256007,38 len=64
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
objid=608002166 ptnid=608002166 pageno=801 offset=56 status=0x800 (0x08
00
(XSTAT_EXPAGE))
cid=0 indid=0
old ts=0x0000 0x000017e3 new ts=0x0000 0x000017e5
xrow:
10003620e7c ( 0): 01020000 0002000c 62020908 ........b...
ENDXACT (256007,40) sessionid=256007,38
attcnt=1 rno=40 op=30 padlen=4 sessionid=256007,38 len=32
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
endstat=COMMIT time=Apr 7 2010 10:22:03:756AM
xstat=0x0 []
BEGINXACT (256007,41) sessionid=256007,41
attcnt=1 rno=41 op=0 padlen=2 sessionid=256007,41 len=64
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
masterxsid=(invalid sessionid)
xstat=XBEG_ENDXACT,
spid=1 suid=1 uid=1 masterdbid=0 dtmcord=0
name=$ins time=Apr 7 2010 10:22:07:756AM
INSERT (256007,42) sessionid=256007,41
attcnt=1 rno=42 op=4 padlen=0 sessionid=256007,41 len=64
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
objid=608002166 ptnid=608002166 pageno=801 offset=68 status=0x800 (0x08
00
(XSTAT_EXPAGE))
cid=0 indid=0
old ts=0x0000 0x000017e5 new ts=0x0000 0x000017e7
xrow:
10003620f1c ( 0): 01030000 0003000c 63020908 ........c...
ENDXACT (256007,43) sessionid=256007,41
attcnt=1 rno=43 op=30 padlen=4 sessionid=256007,41 len=32
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
endstat=COMMIT time=Apr 7 2010 10:22:07:756AM
xstat=0x0 []
接着,向表中添加一个identity字段。
alter table t add col2 int identity not null
go
再利用dbcc log分析日志,我们可以看出在这四行数据上面发生了延迟更新(op=6,INSID在日志类型中是延迟更新的意思!)。
每行数据的页号和偏移变成了:
row1. pageno=801 offset=32
row2. pageno=801 offset=49
row3. pageno=801 offset=66
row4. pageno=801 offset=83
INSIND (256008,24) sessionid=256008,2
attcnt=1 rno=24 op=6 padlen=2 sessionid=256008,2 len=64
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
objid=608002166 ptnid=608002166 pageno=801 offset=32 status=0x2000 (0x2
000
(XSTAT_EXTABLE))
cid=0 indid=0
old ts=0x0000 0x000017f8 new ts=0x0000 0x000017f9
data rnum 0 ptr=(256008,13)
INSIND (256008,25) sessionid=256008,2
attcnt=1 rno=25 op=6 padlen=2 sessionid=256008,2 len=64
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
objid=608002166 ptnid=608002166 pageno=801 offset=49 status=0x2000 (0x2
000
(XSTAT_EXTABLE))
cid=0 indid=0
old ts=0x0000 0x000017f9 new ts=0x0000 0x000017fa
data rnum 1 ptr=(256008,15)
INSIND (256008,26) sessionid=256008,2
attcnt=1 rno=26 op=6 padlen=2 sessionid=256008,2 len=64
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
objid=608002166 ptnid=608002166 pageno=801 offset=66 status=0x2000 (0x2
000
(XSTAT_EXTABLE))
cid=0 indid=0
old ts=0x0000 0x000017fa new ts=0x0000 0x000017fb
data rnum 2 ptr=(256008,17)
INSIND (256008,27) sessionid=256008,2
attcnt=1 rno=27 op=6 padlen=2 sessionid=256008,2 len=64
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
objid=608002166 ptnid=608002166 pageno=801 offset=83 status=0x2000 (0x2
000
(XSTAT_EXTABLE))
cid=0 indid=0
old ts=0x0000 0x000017fb new ts=0x0000 0x000017fc
data rnum 3 ptr=(256008,19)
比较一下前后的各行的偏移量。我们发现:第一行没有移动,第二行向下移动了5(49-44)字节,第三行向下移动了10字节,第四行向下移动了15字节(83-68)。也就是说,每行增加了5个字节的数据。5个字节是因为:int类型占用4个字节再加一个字节的长度。
关于alter table add语法方面的
在向表添加列时是不能够添加not null 列的。错误如下所示:
1> alter table t add col4 char(30) not null
2> go
Msg 4997, Level 16, State 1:
Server 'SYB_NFJD_TEST', Line 1:
ALTER TABLE 't' failed. Default clause is required in order to add non-NULL
column 'col4'.
1> alter table t add col4 int not null
2> go
Msg 4997, Level 16, State 1:
Server 'SYB_NFJD_TEST', Line 1:
ALTER TABLE 't' failed. Default clause is required in order to add non-NULL
column 'col4'.
1>
1. 只能添加为空的字段。
2. 但是,本文前面的向表添加identity类型的int 非空字段却可以。alter table t add col2 int identity not null却可以。
3. 这似乎和SQL标准中的不太一致。
4. 分析page:801页面上的数据。发现最后添加的identity列居然是作为可变长字段进行存储的。字段col即使被定义为非空,但是物理存储上却是作为可变长存储的。因为是varchar类型。
注意: 后来我通过试验发现有一种例外情况。就是新增一个非空列的时候对这列指定默认值,就可以成功增加这列。
比如:alter table test add COLC char(1) default "0" not null
这条语句就能够成功执行!
删除表上的字段的时候报错:
1> alter table t drop col2
2> go
Msg 11052, Level 16, State 1:
Server 'SYB_NFJD_TEST', Line 1:
The 'select into' database option is not enabled for database 'testdb'. ALTER
TABLE with data copy cannot be done. Set the 'select into' database option and
re-run.
1>
报错的原因是表t所在的数据库testdb没有打开select into buklcopy选项。
打开testdb的select into/bulkcopy/pllsort 选项
1> use master
2> go
1> sp_dboption testdb,'select into',true
2> go
Database option 'select into/bulkcopy/pllsort' turned ON for database 'testdb'.
Running CHECKPOINT on database 'testdb' for option 'select
into/bulkcopy/pllsort' to take effect.
(return status = 0)
再次执行删除列的操作,可以执行成功!
1> use testdb
2> go
1> alter table t drop col2
2> go
(4 rows affected)
删除完col2之后,再次分析一下dbcc log的结果。
发现背后进行的操作有三步:
第一:删除表t在systabstats上的统计信息并重建;
第二:删除在系统表sysstatistics,sysobjects,syscolumns,sysindexes,syspartitions上对应记录的索引然后重建;
第三:更新在系统表sysstatistics,sysobjects,syscolumns,sysindexes,syspartitions上对应记录的信息。
删除表上的列的过程的日志信息,如下:
BEGINXACT (256038,36) sessionid=256038,36
attcnt=1 rno=36 op=0 padlen=2 sessionid=256038,36 len=104
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
masterxsid=(invalid sessionid)
xstat=XBEG_ENDXACT,
spid=1 suid=1 uid=1 masterdbid=0 dtmcord=0
name=$ALTER TABLE ADM t ID=880003135 dbid=4 fid=1 time=Apr 7 2010
12:43:21:076PM
BT_DELETE (256038,37) sessionid=256038,36
attcnt=1 rno=37 op=72 padlen=7 sessionid=256038,36 len=88
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
objid=23 systabstats indid=2 ptnid=23 pageno=209 level=0 root=208 cid=0
status=0x00 (0x0000)
slot=90 ridposn=0 oldposn=0
old ts=0x0000 0x00001c54 new ts=0x0000 0x00001c86
B-tree key:
10003624c20 ( 0): 003473c8 3f000034 73c83f00 0000c400 .4s.?..4s.?.....
10003624c30 ( 16): 00 .
DOL_DELETE (256038,38) sessionid=256038,36
attcnt=1 rno=38 op=66 padlen=6 sessionid=256038,36 len=224
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
objectid=23 systabstats ptnid=23 pageno=196 rowno=0 cid=0 erl=0
status (xstat)=0x1000 (0x1000 (XSTAT_DOL_EXROW))
old ts=0x0000 0x00001c7d new ts=0x0000 0x00001c87
xdol_row:
10003624c6a ( 0): 00000000 00000000 3473c83f 00000000 ........4s.?....
10003624c7a ( 16): 00000000 00000001 00000006 00000001 ................
10003624c8a ( 32): 40100000 00000000 00000000 00000000 @...............
10003624c9a ( 48): 00000000 00000000 00000000 00000000 ................
10003624caa ( 64): 00000000 00000000 00000000 00000000 ................
10003624cba ( 80): 00000000 00000000 40378000 00000000 ........@7......
10003624cca ( 96): 00000000 00000000 00000000 00000000 ................
10003624cda ( 112): 3f800000 3f800000 00000000 00000000 ?...?...........
10003624cea ( 128): 00000000 00000000 00000000 00000000 ................
10003624cfa ( 144): 3f800000 3f800000 3473c83f 00000000 ?...?...4s.?....
10003624d0a ( 160): 00009d51 00bf1c77 ...Q...w
DOL_INSERT (256038,39) sessionid=256038,36
attcnt=1 rno=39 op=63 padlen=6 sessionid=256038,36 len=224
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
objectid=23 systabstats ptnid=23 pageno=196 rowno=7 cid=0 erl=0
status (xstat)=0x1000 (0x1000 (XSTAT_DOL_EXROW))
old ts=0x0000 0x00001c87 new ts=0x0000 0x00001c88
xdol_row:
10003624d4a ( 0): 00070004 00000000 3473c83f 00000000 ........4s.?....
10003624d5a ( 16): 00000000 00000001 00000006 00000001 ................
10003624d6a ( 32): 40100000 00000000 00000000 00000000 @...............
10003624d7a ( 48): 00000000 00000000 00000000 00000000 ................
10003624d8a ( 64): 00000000 00000000 00000000 00000000 ................
10003624d9a ( 80): 00000000 00000000 40378000 00000000 ........@7......
10003624daa ( 96): 00000000 00000000 00000000 00000000 ................
10003624dba ( 112): 3f800000 3f800000 00000000 00000000 ?...?...........
10003624dca ( 128): 00000000 00000000 00000000 00000000 ................
10003624dda ( 144): 3f800000 3f800000 3473c83f 00000000 ?...?...4s.?....
10003624dea ( 160): 00009d51 00d1a923 ...Q...#
BT_INSERT (256038,40) sessionid=256038,36
attcnt=1 rno=40 op=71 padlen=7 sessionid=256038,36 len=88
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
objid=23 systabstats indid=2 ptnid=23 pageno=209 level=0 root=208 cid=0
status=0x220 (0x0200 (XSTAT_BT_CHANGE_LCTXREPLACEDEL), 0x0020
(XSTAT_BT_CHANGE_REPLACERID))
slot=90 ridposn=0 oldposn=0
old ts=0x0000 0x00001c86 new ts=0x0000 0x00001c89
B-tree key:
10003624e38 ( 0): 003473c8 3f000034 73c83f00 0000c420 .4s.?..4s.?....
10003624e48 ( 16): 07 .
OAMCREATE (256038,41) sessionid=256038,36
attcnt=1 rno=41 op=41 padlen=4 sessionid=256038,36 len=128
odc_stat=0x0040 (0x0040 (LHSX_SLRXACT))
loh_status: 0x40 (0x00000040 (LHSX_SLRXACT))
xpostcommit_scan_nextpg=3
Page header for page 0x10003624e64
pageno=888 nextpg=888 prevpg=888 ptnid=880003135 timestamp=0000 00001c8a
oampgcount=0 attrcount=0 indid=0 totalentries_lo=0 entrycount=0
page status bits: 0x8004 (0x8000 (PG_OAMPG), 0x0004 (PG_OAMSORT))
old next ts=0x0000 0x00000000 new next ts=0x0000 0x00000000
old prev ts=0x0000 0x00000000 new prev ts=0x0000 0x00000000
oampg=0 cid=0 objid=880003135
extent oampage=0 extptnid=880003135 pgl_status=0x808 (XPG_SET_SORT)
OAMINSERT (256038,42) sessionid=256038,36
attcnt=1 rno=42 op=39 padlen=0 sessionid=256038,36 len=72
odc_stat=0x0140 (0x0100 (LHSR_DO_NOT_UNDO), 0x0040 (LHSX_SLRXACT))
loh_status: 0x140 (0x00000100 (LHSR_DO_NOT_UNDO), 0x00000040 (LHSX_SLRXA
CT))
oampg=888, allocpg=768, xinspg=888
xobjid=880003135 , xindid=0, xptnid=880003135
prev ts=0x0000 0x00001c8a new ts=0x0000 0x00001c8b
hdr prev ts=0x0000 0x00001c8a hdr new ts=0x0000 0x00001c8b
ALLOC (256038,43) sessionid=256038,36
attcnt=1 rno=43 op=13 padlen=4 sessionid=256038,36 len=128
odc_stat=0x0200 (0x0200 (LHSX_POSTCOMMIT_SCAN))
loh_status: 0x200 (0x00000200 (LHSX_POSTCOMMIT_SCAN))
xpostcommit_scan_nextpg=0
Page header for page 0x10003624f2c
pageno=889 nextpg=0 prevpg=0 ptnid=880003135 timestamp=0000 00001c8c
nextrno=0 level=0 indid=0 freeoff=32 minlen=6
page status bits: 0x1 (0x0001 (PG_DATA))
old next ts=0x0000 0x00000000 new next ts=0x0000 0x00000000
old prev ts=0x0000 0x00000000 new prev ts=0x0000 0x00000000
oampg=888 cid=0 objid=880003135
extent oampage=888 extptnid=880003135 pgl_status=0x808 (XPG_SET_SORT)
OAMENTRYMOVE (256039,0) sessionid=256038,36
attcnt=1 rno=0 op=51 padlen=0 sessionid=256038,36 len=144
odc_stat=0x0040 (0x0040 (LHSX_SLRXACT))
loh_status: 0x40 (0x00000040 (LHSX_SLRXACT))
xobjid=880003135 xindid=0 xsrc_ptnid=880003135 xdst_ptnid=0
entries_moved=0, xsrc_cacheid=0 xdst_cacheid=0
xsrc_1st_oampgno=0 xsrc_oampgno=888
xdst_1st_oampgno=0 xdst_oampgno=0
xsrc_1st_oam_oldts=0x0000 0x00000000 xsrc_oam_oldts=0x0000 0x00001c8b
xsrc_1st_oam_newts=0x0000 0x00000000 xsrc_oam_newts=0x0000 0x00001c8d
xdst_1st_oam_oldts=0x0000 0x00000000 xdst_oam_oldts=0x0000 0x00000000
xdst_1st_oam_newts=0x0000 0x00000000 xdst_oam_newts=0x0000 0x00000000
oamentry: allocpg=0 used=0 unused=0
deleted_index=0 reserved=10 xoamvstat=0x0 (0x00)
OAMATPUT (256039,1) sessionid=256038,36
attcnt=1 rno=1 op=52 padlen=0 sessionid=256038,36 len=120
odc_stat=0x0040 (0x0040 (LHSX_SLRXACT))
loh_status: 0x40 (0x00000040 (LHSX_SLRXACT))
objid=880003135 ptnid=880003135 pageno=888 offset=10 status=0x00 (0x000
0)
cid=0 indid=0
old ts=0x0000 0x00001c8d new ts=0x0000 0x00001c8f
xvallen=64
newval:
100032660e8 ( 0): 00000000 00000000 00000000 00000000 ................
100032660f8 ( 16): 00000000 00000000 00000000 00000000 ................
10003266108 ( 32): 00000000 00000000 00000000 00000000 ................
10003266118 ( 48): 00000000 00000000 00000000 00000000 ................
10003266128 ( 64):
DROPEXTSMAP (256039,2) sessionid=256038,36
attcnt=1 rno=2 op=77 padlen=4 sessionid=256038,36 len=152
odc_stat=0x0200 (0x0200 (LHSX_POSTCOMMIT_SCAN))
loh_status: 0x200 (0x00000200 (LHSX_POSTCOMMIT_SCAN))
xpostcommit_scan_nextpg=256039
objid=880003135 , indid=0 ptnid=880003135 de_status=0x00 (0x0000)
de_allocpg=768, de_oamretainpg (saved oam pg)=0, de_retainpg (saved pg)=
0,
de_cid (cache ID)=0
Extent map: 0x08000000
Extents in use:
Extid: 800
Alloc : 0x03 ( 800 801 )
Dealloc : 0x00 ( )
DOL_UPDATE (256039,3) sessionid=256038,36
attcnt=1 rno=3 op=65 padlen=0 sessionid=256038,36 len=64
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
objectid=2 sysindexes ptnid=2 pageno=19 rowno=18 cid=0 erl=0
status (xstat)=0x00 (0x0000)
status2 (xstat2)=0x04 (0x0004 (XSTAT2_DOL_SHROW))
old ts=0x0000 0x00001c6c new ts=0x0000 0x00001c90
xfirstoff=0, xoldvlen=0, xnewvlen=0
xoldstatus=0x0c: (0x0008 (DOL_ROW_UPDATED), 0x0004 (DOL_ROW_POSSUNCMT))
xnewstatus=0x0c: (0x0008 (DOL_ROW_UPDATED), 0x0004 (DOL_ROW_POSSUNCMT))
old image:
10003266200 ( 0):
new image:
10003266200 ( 0):
DOL_UPDATE (256039,4) sessionid=256038,36
attcnt=1 rno=4 op=65 padlen=6 sessionid=256038,36 len=72
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
objectid=2 sysindexes ptnid=2 pageno=19 rowno=18 cid=0 erl=0
status (xstat)=0x00 (0x0000)
status2 (xstat2)=0x04 (0x0004 (XSTAT2_DOL_SHROW))
old ts=0x0000 0x00001c90 new ts=0x0000 0x00001c91
xfirstoff=57, xoldvlen=1, xnewvlen=1
xoldstatus=0x0c: (0x0008 (DOL_ROW_UPDATED), 0x0004 (DOL_ROW_POSSUNCMT))
xnewstatus=0x0c: (0x0008 (DOL_ROW_UPDATED), 0x0004 (DOL_ROW_POSSUNCMT))
old image: 46
10003266240 ( 0): 2e .
new image: 41
10003266241 ( 0): 29 )
DOL_UPDATE (256039,5) sessionid=256038,36
attcnt=1 rno=5 op=65 padlen=6 sessionid=256038,36 len=72
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
objectid=28 syspartitions ptnid=28 pageno=82 rowno=16 cid=0 erl=0
status (xstat)=0x00 (0x0000)
status2 (xstat2)=0x04 (0x0004 (XSTAT2_DOL_SHROW))
old ts=0x0000 0x00001c50 new ts=0x0000 0x00001c92
xfirstoff=35, xoldvlen=1, xnewvlen=1
xoldstatus=0x08: (0x0008 (DOL_ROW_UPDATED))
xnewstatus=0x08: (0x0008 (DOL_ROW_UPDATED))
old image: 33
10003266288 ( 0): 21 !
new image: 121
10003266289 ( 0): 79 y
DOL_UPDATE (256039,6) sessionid=256038,36
attcnt=1 rno=6 op=65 padlen=6 sessionid=256038,36 len=72
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
objectid=28 syspartitions ptnid=28 pageno=82 rowno=16 cid=0 erl=0
status (xstat)=0x00 (0x0000)
status2 (xstat2)=0x04 (0x0004 (XSTAT2_DOL_SHROW))
old ts=0x0000 0x00001c92 new ts=0x0000 0x00001c93
xfirstoff=39, xoldvlen=1, xnewvlen=1
xoldstatus=0x0c: (0x0008 (DOL_ROW_UPDATED), 0x0004 (DOL_ROW_POSSUNCMT))
xnewstatus=0x0c: (0x0008 (DOL_ROW_UPDATED), 0x0004 (DOL_ROW_POSSUNCMT))
old image: 33
100032662d0 ( 0): 21 !
new image: 121
100032662d1 ( 0): 79 y
DOL_UPDATE (256039,7) sessionid=256038,36
attcnt=1 rno=7 op=65 padlen=6 sessionid=256038,36 len=72
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
objectid=28 syspartitions ptnid=28 pageno=82 rowno=16 cid=0 erl=0
status (xstat)=0x00 (0x0000)
status2 (xstat2)=0x04 (0x0004 (XSTAT2_DOL_SHROW))
old ts=0x0000 0x00001c93 new ts=0x0000 0x00001c94
xfirstoff=27, xoldvlen=1, xnewvlen=1
xoldstatus=0x0c: (0x0008 (DOL_ROW_UPDATED), 0x0004 (DOL_ROW_POSSUNCMT))
xnewstatus=0x0c: (0x0008 (DOL_ROW_UPDATED), 0x0004 (DOL_ROW_POSSUNCMT))
old image: 32
10003266318 ( 0): 20
new image: 120
10003266319 ( 0): 78 x
DOL_UPDATE (256039,8) sessionid=256038,36
attcnt=1 rno=8 op=65 padlen=6 sessionid=256038,36 len=72
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
objectid=28 syspartitions ptnid=28 pageno=82 rowno=16 cid=0 erl=0
status (xstat)=0x00 (0x0000)
status2 (xstat2)=0x04 (0x0004 (XSTAT2_DOL_SHROW))
old ts=0x0000 0x00001c94 new ts=0x0000 0x00001c95
xfirstoff=23, xoldvlen=1, xnewvlen=1
xoldstatus=0x0c: (0x0008 (DOL_ROW_UPDATED), 0x0004 (DOL_ROW_POSSUNCMT))
xnewstatus=0x0c: (0x0008 (DOL_ROW_UPDATED), 0x0004 (DOL_ROW_POSSUNCMT))
old image: 0
10003266360 ( 0): 00 .
new image: 2
10003266361 ( 0): 02 .
DOL_UPDATE (256039,9) sessionid=256038,36
attcnt=1 rno=9 op=65 padlen=2 sessionid=256038,36 len=72
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
objectid=2 sysindexes ptnid=2 pageno=19 rowno=18 cid=0 erl=0
status (xstat)=0x00 (0x0000)
status2 (xstat2)=0x04 (0x0004 (XSTAT2_DOL_SHROW))
old ts=0x0000 0x00001c91 new ts=0x0000 0x00001c96
xfirstoff=80, xoldvlen=3, xnewvlen=3
xoldstatus=0x0c: (0x0008 (DOL_ROW_UPDATED), 0x0004 (DOL_ROW_POSSUNCMT))
xnewstatus=0x0c: (0x0008 (DOL_ROW_UPDATED), 0x0004 (DOL_ROW_POSSUNCMT))
old image:
100032663a8 ( 0): beb176 ..v
new image:
100032663ab ( 0): d1a923 ..#
BT_DELETE (256039,10) sessionid=256038,36
attcnt=1 rno=10 op=72 padlen=1 sessionid=256038,36 len=80
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
objid=3 syscolumns indid=2 ptnid=3 pageno=53 level=0 root=49 cid=0 statu
s=0x00
(0x0000)
slot=14 ridposn=0 oldposn=0
old ts=0x0000 0x00001c6b new ts=0x0000 0x00001c97
B-tree key:
100032663f0 ( 0): 003473c8 3f000000 01000000 2e0035 .4s.?.........5
DOL_DELETE (256039,11) sessionid=256038,36
attcnt=1 rno=11 op=66 padlen=4 sessionid=256038,36 len=96
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
objectid=3 syscolumns ptnid=3 pageno=46 rowno=53 cid=0 erl=0
status (xstat)=0x1000 (0x1000 (XSTAT_DOL_EXROW))
old ts=0x0000 0x00001c6a new ts=0x0000 0x00001c98
xdol_row:
10003266432 ( 0): 00350000 00010000 3473c83f 00010038 .5......4s.?...8
10003266442 ( 16): 00000004 00020000 00000007 00000000 ................
10003266452 ( 32): 00000000 002a6964 0026 .....*id.&
BT_DELETE (256039,12) sessionid=256038,36
attcnt=1 rno=12 op=72 padlen=1 sessionid=256038,36 len=80
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
objid=3 syscolumns indid=2 ptnid=3 pageno=53 level=0 root=49 cid=0 statu
s=0x00
(0x0000)
slot=15 ridposn=0 oldposn=0
old ts=0x0000 0x00001c97 new ts=0x0000 0x00001c99
B-tree key:
100032664a0 ( 0): 003473c8 3f000000 02000000 2e0036 .4s.?.........6
DOL_DELETE (256039,13) sessionid=256038,36
attcnt=1 rno=13 op=66 padlen=2 sessionid=256038,36 len=96
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
objectid=3 syscolumns ptnid=3 pageno=46 rowno=54 cid=0 erl=0
status (xstat)=0x1000 (0x1000 (XSTAT_DOL_EXROW))
old ts=0x0000 0x00001c98 new ts=0x0000 0x00001c9a
xdol_row:
100032664e2 ( 0): 00360000 00010000 3473c83f 00020027 .6......4s.?...'
100032664f2 ( 16): 0000001e ffff0000 00000002 00000000 ................
10003266502 ( 32): 00000000 002c6e61 6d650026 .....,name.&
BT_DELETE (256039,14) sessionid=256038,36
attcnt=1 rno=14 op=72 padlen=1 sessionid=256038,36 len=80
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
objid=3 syscolumns indid=2 ptnid=3 pageno=53 level=0 root=49 cid=0 statu
s=0x00
(0x0000)
slot=16 ridposn=0 oldposn=0
old ts=0x0000 0x00001c99 new ts=0x0000 0x00001c9b
B-tree key:
10003266550 ( 0): 003473c8 3f000000 03000000 2e0037 .4s.?.........7
DOL_DELETE (256039,15) sessionid=256038,36
attcnt=1 rno=15 op=66 padlen=2 sessionid=256038,36 len=96
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
objectid=3 syscolumns ptnid=3 pageno=46 rowno=55 cid=0 erl=0
status (xstat)=0x1000 (0x1000 (XSTAT_DOL_EXROW))
old ts=0x0000 0x00001c9a new ts=0x0000 0x00001c9c
xdol_row:
10003266592 ( 0): 00370000 00010000 3473c83f 00038026 .7......4s.?...&
100032665a2 ( 16): 00000004 fffe0000 00000007 00000000 ................
100032665b2 ( 32): 00000000 002c636f 6c320026 .....,col2.&
DOL_INSERT (256039,16) sessionid=256038,36
attcnt=1 rno=16 op=63 padlen=4 sessionid=256038,36 len=96
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
objectid=3 syscolumns ptnid=3 pageno=46 rowno=78 cid=0 erl=0
status (xstat)=0x1000 (0x1000 (XSTAT_DOL_EXROW))
old ts=0x0000 0x00001c9c new ts=0x0000 0x00001c9d
xdol_row:
100032665f2 ( 0): 004e0004 00010000 3473c83f 00010038 .N......4s.?...8
10003266602 ( 16): 00000004 00020000 00000007 00000000 ................
10003266612 ( 32): 00000000 002a6964 0026 .....*id.&
BT_INSERT (256039,17) sessionid=256038,36
attcnt=1 rno=17 op=71 padlen=1 sessionid=256038,36 len=80
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
objid=3 syscolumns indid=2 ptnid=3 pageno=53 level=0 root=49 cid=0 statu
s=0x220
(0x0200 (XSTAT_BT_CHANGE_LCTXREPLACEDEL), 0x0020 (XSTAT_BT_CHANGE_REPLACERID))
slot=14 ridposn=0 oldposn=0
old ts=0x0000 0x00001c9b new ts=0x0000 0x00001c9e
B-tree key:
10003266660 ( 0): 003473c8 3f000000 01000000 2e204e .4s.?........ N
DOL_INSERT (256039,18) sessionid=256038,36
attcnt=1 rno=18 op=63 padlen=2 sessionid=256038,36 len=96
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
objectid=3 syscolumns ptnid=3 pageno=46 rowno=79 cid=0 erl=0
status (xstat)=0x1000 (0x1000 (XSTAT_DOL_EXROW))
old ts=0x0000 0x00001c9d new ts=0x0000 0x00001c9f
xdol_row:
100032666a2 ( 0): 004f0004 00010000 3473c83f 00020027 .O......4s.?...'
100032666b2 ( 16): 0000001e ffff0000 00000002 00000000 ................
100032666c2 ( 32): 00000000 002c6e61 6d650026 .....,name.&
BT_INSERT (256039,19) sessionid=256038,36
attcnt=1 rno=19 op=71 padlen=1 sessionid=256038,36 len=80
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
objid=3 syscolumns indid=2 ptnid=3 pageno=53 level=0 root=49 cid=0 statu
s=0x220
(0x0200 (XSTAT_BT_CHANGE_LCTXREPLACEDEL), 0x0020 (XSTAT_BT_CHANGE_REPLACERID))
slot=15 ridposn=0 oldposn=0
old ts=0x0000 0x00001c9e new ts=0x0000 0x00001ca0
B-tree key:
10003266710 ( 0): 003473c8 3f000000 02000000 2e204f .4s.?........ O
DOL_UPDATE (256039,20) sessionid=256038,36
attcnt=1 rno=20 op=65 padlen=0 sessionid=256038,36 len=64
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
objectid=28 syspartitions ptnid=28 pageno=82 rowno=16 cid=0 erl=0
status (xstat)=0x00 (0x0000)
status2 (xstat2)=0x04 (0x0004 (XSTAT2_DOL_SHROW))
old ts=0x0000 0x00001c95 new ts=0x0000 0x00001ca1
xfirstoff=0, xoldvlen=0, xnewvlen=0
xoldstatus=0x0c: (0x0008 (DOL_ROW_UPDATED), 0x0004 (DOL_ROW_POSSUNCMT))
xnewstatus=0x0c: (0x0008 (DOL_ROW_UPDATED), 0x0004 (DOL_ROW_POSSUNCMT))
old image:
10003266760 ( 0):
new image:
10003266760 ( 0):
DOL_UPDATE (256039,21) sessionid=256038,36
attcnt=1 rno=21 op=65 padlen=0 sessionid=256038,36 len=64
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
objectid=1 sysobjects ptnid=1 pageno=1 rowno=30 cid=0 erl=0
status (xstat)=0x00 (0x0000)
status2 (xstat2)=0x04 (0x0004 (XSTAT2_DOL_SHROW))
old ts=0x0000 0x00001c77 new ts=0x0000 0x00001ca2
xfirstoff=0, xoldvlen=0, xnewvlen=0
xoldstatus=0x0c: (0x0008 (DOL_ROW_UPDATED), 0x0004 (DOL_ROW_POSSUNCMT))
xnewstatus=0x0c: (0x0008 (DOL_ROW_UPDATED), 0x0004 (DOL_ROW_POSSUNCMT))
old image:
100032667a0 ( 0):
new image:
100032667a0 ( 0):
DOL_UPDATE (256039,22) sessionid=256038,36
attcnt=1 rno=22 op=65 padlen=6 sessionid=256038,36 len=72
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
objectid=1 sysobjects ptnid=1 pageno=1 rowno=30 cid=0 erl=0
status (xstat)=0x00 (0x0000)
status2 (xstat2)=0x04 (0x0004 (XSTAT2_DOL_SHROW))
old ts=0x0000 0x00001ca2 new ts=0x0000 0x00001ca3
xfirstoff=23, xoldvlen=1, xnewvlen=1
xoldstatus=0x0c: (0x0008 (DOL_ROW_UPDATED), 0x0004 (DOL_ROW_POSSUNCMT))
xnewstatus=0x0c: (0x0008 (DOL_ROW_UPDATED), 0x0004 (DOL_ROW_POSSUNCMT))
old image: 64
100032667e0 ( 0): 40 @
new image: 0
100032667e1 ( 0): 00 .
DOL_UPDATE (256039,23) sessionid=256038,36
attcnt=1 rno=23 op=65 padlen=6 sessionid=256038,36 len=72
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
objectid=1 sysobjects ptnid=1 pageno=1 rowno=30 cid=0 erl=0
status (xstat)=0x00 (0x0000)
status2 (xstat2)=0x04 (0x0004 (XSTAT2_DOL_SHROW))
old ts=0x0000 0x00001ca3 new ts=0x0000 0x00001ca4
xfirstoff=25, xoldvlen=1, xnewvlen=1
xoldstatus=0x0c: (0x0008 (DOL_ROW_UPDATED), 0x0004 (DOL_ROW_POSSUNCMT))
xnewstatus=0x0c: (0x0008 (DOL_ROW_UPDATED), 0x0004 (DOL_ROW_POSSUNCMT))
old image: 0
10003266828 ( 0): 00 .
new image: 1
10003266829 ( 0): 01 .
DOL_UPDATE (256039,24) sessionid=256038,36
attcnt=1 rno=24 op=65 padlen=6 sessionid=256038,36 len=72
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
objectid=1 sysobjects ptnid=1 pageno=1 rowno=30 cid=0 erl=0
status (xstat)=0x00 (0x0000)
status2 (xstat2)=0x04 (0x0004 (XSTAT2_DOL_SHROW))
old ts=0x0000 0x00001ca4 new ts=0x0000 0x00001ca5
xfirstoff=17, xoldvlen=1, xnewvlen=1
xoldstatus=0x0c: (0x0008 (DOL_ROW_UPDATED), 0x0004 (DOL_ROW_POSSUNCMT))
xnewstatus=0x0c: (0x0008 (DOL_ROW_UPDATED), 0x0004 (DOL_ROW_POSSUNCMT))
old image: 0
10003266870 ( 0): 00 .
new image: 1
10003266871 ( 0): 01 .
DOL_UPDATE (256039,25) sessionid=256038,36
attcnt=1 rno=25 op=65 padlen=6 sessionid=256038,36 len=72
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
objectid=1 sysobjects ptnid=1 pageno=1 rowno=30 cid=0 erl=0
status (xstat)=0x00 (0x0000)
status2 (xstat2)=0x04 (0x0004 (XSTAT2_DOL_SHROW))
old ts=0x0000 0x00001ca5 new ts=0x0000 0x00001ca6
xfirstoff=19, xoldvlen=1, xnewvlen=1
xoldstatus=0x0c: (0x0008 (DOL_ROW_UPDATED), 0x0004 (DOL_ROW_POSSUNCMT))
xnewstatus=0x0c: (0x0008 (DOL_ROW_UPDATED), 0x0004 (DOL_ROW_POSSUNCMT))
old image: 1
100032668b8 ( 0): 01 .
new image: 2
100032668b9 ( 0): 02 .
DOL_UPDATE (256039,26) sessionid=256038,36
attcnt=1 rno=26 op=65 padlen=6 sessionid=256038,36 len=224
odc_stat=0x0100 (0x0100 (LHSR_DO_NOT_UNDO))
loh_status: 0x100 (0x00000100 (LHSR_DO_NOT_UNDO))
objectid=23 systabstats ptnid=23 pageno=196 rowno=7 cid=0 erl=0
status (xstat)=0x1000 (0x1000 (XSTAT_DOL_EXROW))
status2 (xstat2)=0x10 (0x0010 (XSTAT2_DOLUPD_ROW_IMAGE))
old ts=0x0000 0x00001c88 new ts=0x0000 0x00001ca7
Redo-only log record
100032668f4 ( 0): 00040000 00003473 c83f0000 00000000 ......4s.?......
10003266904 ( 16): 00000000 00010000 00060000 00014010 ..............@.
10003266914 ( 32): 00000000 00000000 00000000 00000000 ................
10003266924 ( 48): 00000000 00000000 00000000 00000000 ................
10003266934 ( 64): 00000000 00000000 00000000 00000000 ................
10003266944 ( 80): 00020000 00004037 80000000 00000000 ......@7........
10003266954 ( 96): 00000000 00000000 00000000 00003f80 ..............?.
10003266964 ( 112): 00003f80 00000000 00000000 00000000 ..?.............
10003266974 ( 128): 00000000 00000000 00000000 00003f80 ..............?.
10003266984 ( 144): 00003f80 00003473 c83f0000 00000000 ..?...4s.?......
10003266994 ( 160): 9d5100d1 a923 .Q...#
BT_DELETE (256039,27) sessionid=256038,36
attcnt=1 rno=27 op=72 padlen=7 sessionid=256038,36 len=88
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
objid=23 systabstats indid=2 ptnid=23 pageno=209 level=0 root=208 cid=0
status=0x00 (0x0000)
slot=90 ridposn=0 oldposn=0
old ts=0x0000 0x00001c89 new ts=0x0000 0x00001ca8
B-tree key:
100032669e0 ( 0): 003473c8 3f000034 73c83f00 0000c420 .4s.?..4s.?....
100032669f0 ( 16): 07 .
DOL_UPDATE (256039,28) sessionid=256038,36
attcnt=1 rno=28 op=65 padlen=4 sessionid=256038,36 len=256
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
objectid=23 systabstats ptnid=23 pageno=196 rowno=7 cid=0 erl=0
status (xstat)=0x1000 (0x1000 (XSTAT_DOL_EXROW))
status2 (xstat2)=0x00 (0x0000)
old ts=0x0000 0x00001ca7 new ts=0x0000 0x00001ca9
xfirstoff=56, xoldvlen=94, xnewvlen=94
xoldstatus=0x04: (0x0004 (DOL_ROW_POSSUNCMT))
xnewstatus=0x0c: (0x0008 (DOL_ROW_UPDATED), 0x0004 (DOL_ROW_POSSUNCMT))
old image:
10003266a38 ( 0): 00000000 00000000 00000000 00000000 ................
10003266a48 ( 16): 00000000 00000000 00000002 00000000 ................
10003266a58 ( 32): 40378000 00000000 00000000 00000000 @7..............
10003266a68 ( 48): 00000000 00000000 3f800000 3f800000 ........?...?...
10003266a78 ( 64): 00000000 00000000 00000000 00000000 ................
10003266a88 ( 80): 00000000 00000000 3f800000 3f80 ........?...?.
new image:
10003266a96 ( 0): 3ff00000 00000000 00000000 00000000 ?...............
10003266aa6 ( 16): 00000000 00000000 00000002 00000000 ................
10003266ab6 ( 32): 40378000 00000000 00000000 00000000 @7..............
10003266ac6 ( 48): 00000000 00000000 00000000 00000000 ................
10003266ad6 ( 64): 00000000 00000000 00000000 00000000 ................
10003266ae6 ( 80): 00000000 00000000 00000000 0000 ..............
BT_INSERT (256039,29) sessionid=256038,36
attcnt=1 rno=29 op=71 padlen=7 sessionid=256038,36 len=88
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
objid=23 systabstats indid=2 ptnid=23 pageno=209 level=0 root=208 cid=0
status=0x20 (0x0020 (XSTAT_BT_CHANGE_REPLACERID))
slot=90 ridposn=0 oldposn=0
old ts=0x0000 0x00001ca8 new ts=0x0000 0x00001caa
B-tree key:
10003266b38 ( 0): 003473c8 3f000034 73c83f00 0000c420 .4s.?..4s.?....
10003266b48 ( 16): 07 .
BT_DELETE (256039,30) sessionid=256038,36
attcnt=1 rno=30 op=72 padlen=3 sessionid=256038,36 len=80
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
objid=2 sysindexes indid=2 ptnid=2 pageno=34 level=0 root=33 cid=0 statu
s=0x00
(0x0000)
slot=93 ridposn=0 oldposn=0
old ts=0x0000 0x00001c49 new ts=0x0000 0x00001cab
B-tree key:
10003266b90 ( 0): 003473c8 3f000000 00001300 12 .4s.?........
DOL_DELETE (256039,31) sessionid=256038,36
attcnt=1 rno=31 op=66 padlen=5 sessionid=256038,36 len=168
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
objectid=2 sysindexes ptnid=2 pageno=19 rowno=18 cid=0 erl=0
status (xstat)=0x1000 (0x1000 (XSTAT_DOL_EXROW))
old ts=0x0000 0x00001c96 new ts=0x0000 0x00001cac
xdol_row:
10003266bd2 ( 0): 0012000c 000c0000 3473c83f 00000000 ........4s.?....
10003266be2 ( 16): 00000000 00000000 00000000 00000000 ................
10003266bf2 ( 32): 00000000 00000000 00000000 32010000 ............2...
10003266c02 ( 48): 00010000 00000006 00290000 00000071 .........).....q
10003266c12 ( 64): 74000000 00000000 00000000 009d5100 t.............Q.
10003266c22 ( 80): d1a92300 03000000 00005500 53004b00 ..#.......U.S.K.
10003266c32 ( 96): 47204700 45004300 41204100 40204020 G G.E.C.A A.@ @
10003266c42 ( 112): 40 @
DOL_INSERT (256039,32) sessionid=256038,36
attcnt=1 rno=32 op=63 padlen=1 sessionid=256038,36 len=160
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
objectid=2 sysindexes ptnid=2 pageno=19 rowno=25 cid=0 erl=0
status (xstat)=0x1000 (0x1000 (XSTAT_DOL_EXROW))
old ts=0x0000 0x00001cac new ts=0x0000 0x00001cad
xdol_row:
10003266c7a ( 0): 00190004 000c0000 3473c83f 00000000 ........4s.?....
10003266c8a ( 16): 00000000 00000000 00000000 00000000 ................
10003266c9a ( 32): 00000000 00000000 00000000 32010000 ............2...
10003266caa ( 48): 00010000 00000006 00290000 0000006d .........).....m
10003266cba ( 64): 74000000 00000000 009d5100 d1a92300 t.........Q...#.
10003266cca ( 80): 03000000 00005100 4f004720 47204700 ......Q.O.G G G.
10003266cda ( 96): 45004300 41204100 40204020 40 E.C.A A.@ @ @
BT_INSERT (256039,33) sessionid=256038,36
attcnt=1 rno=33 op=71 padlen=3 sessionid=256038,36 len=80
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
objid=2 sysindexes indid=2 ptnid=2 pageno=34 level=0 root=33 cid=0 statu
s=0x220
(0x0200 (XSTAT_BT_CHANGE_LCTXREPLACEDEL), 0x0020 (XSTAT_BT_CHANGE_REPLACERID))
slot=93 ridposn=0 oldposn=0
old ts=0x0000 0x00001cab new ts=0x0000 0x00001cae
B-tree key:
10003266d28 ( 0): 003473c8 3f000000 00001320 19 .4s.?...... .
BT_DELETE (256039,34) sessionid=256038,36
attcnt=1 rno=34 op=72 padlen=7 sessionid=256038,36 len=88
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
objid=28 syspartitions indid=2 ptnid=28 pageno=90 level=0 root=89 cid=0
status=0x00 (0x0000)
slot=93 ridposn=0 oldposn=0
old ts=0x0000 0x00001c45 new ts=0x0000 0x00001caf
B-tree key:
10003266d78 ( 0): 003473c8 3f000034 73c83f00 00005200 .4s.?..4s.?...R.
10003266d88 ( 16): 10 .
BT_DELETE (256039,35) sessionid=256038,36
attcnt=1 rno=35 op=72 padlen=3 sessionid=256038,36 len=80
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
objid=28 syspartitions indid=3 ptnid=28 pageno=113 level=0 root=112 cid=
0
status=0x00 (0x0000)
slot=93 ridposn=0 oldposn=0
old ts=0x0000 0x00001c46 new ts=0x0000 0x00001cb0
B-tree key:
10003266dd0 ( 0): 003473c8 3f000000 00005220 10 .4s.?.....R .
BT_DELETE (256039,36) sessionid=256038,36
attcnt=1 rno=36 op=72 padlen=7 sessionid=256038,36 len=96
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
objid=28 syspartitions indid=4 ptnid=28 pageno=129 level=0 root=128 cid=
0
status=0x00 (0x0000)
slot=93 ridposn=0 oldposn=0
old ts=0x0000 0x00001c47 new ts=0x0000 0x00001cb1
B-tree key:
10003266e20 ( 0): 013473c8 3f000000 00005220 100b745f .4s.?.....R ..t_
10003266e30 ( 16): 38383030 30333133 35 880003135
DOL_DELETE (256039,37) sessionid=256038,36
attcnt=1 rno=37 op=66 padlen=1 sessionid=256038,36 len=120
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
objectid=28 syspartitions ptnid=28 pageno=82 rowno=16 cid=0 erl=0
status (xstat)=0x1000 (0x1000 (XSTAT_DOL_EXROW))
old ts=0x0000 0x00001ca1 new ts=0x0000 0x00001cb2
xdol_row:
10003266e72 ( 0): 0010000c 00010000 3473c83f 3473c83f ........4s.?4s.?
10003266e82 ( 16): 00010000 00000002 00000378 00000000 ...........x....
10003266e92 ( 32): 00000379 00000379 00000000 00009d51 ...y...y.......Q
10003266ea2 ( 48): 00beb176 00000045 745f3838 30303033 ...v...Et_880003
10003266eb2 ( 64): 31333500 38 135.8
DOL_INSERT (256039,38) sessionid=256038,36
attcnt=1 rno=38 op=63 padlen=1 sessionid=256038,36 len=120
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
objectid=28 syspartitions ptnid=28 pageno=82 rowno=23 cid=0 erl=0
status (xstat)=0x1000 (0x1000 (XSTAT_DOL_EXROW))
old ts=0x0000 0x00001cb2 new ts=0x0000 0x00001cb3
xdol_row:
10003266eea ( 0): 00170004 00010000 3473c83f 3473c83f ........4s.?4s.?
10003266efa ( 16): 00010000 00000002 00000378 00000000 ...........x....
10003266f0a ( 32): 00000379 00000379 00000000 00009d51 ...y...y.......Q
10003266f1a ( 48): 00d1a923 00000045 745f3838 30303033 ...#...Et_880003
10003266f2a ( 64): 31333500 38 135.8
BT_INSERT (256039,39) sessionid=256038,36
attcnt=1 rno=39 op=71 padlen=7 sessionid=256038,36 len=88
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
objid=28 syspartitions indid=2 ptnid=28 pageno=90 level=0 root=89 cid=0
status=0x220 (0x0200 (XSTAT_BT_CHANGE_LCTXREPLACEDEL), 0x0020
(XSTAT_BT_CHANGE_REPLACERID))
slot=93 ridposn=0 oldposn=0
old ts=0x0000 0x00001caf new ts=0x0000 0x00001cb4
B-tree key:
10003266f70 ( 0): 003473c8 3f000034 73c83f00 00005220 .4s.?..4s.?...R
10003266f80 ( 16): 17 .
BT_INSERT (256040,0) sessionid=256038,36
attcnt=1 rno=0 op=71 padlen=3 sessionid=256038,36 len=80
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
objid=28 syspartitions indid=3 ptnid=28 pageno=113 level=0 root=112 cid=
0
status=0x220 (0x0200 (XSTAT_BT_CHANGE_LCTXREPLACEDEL), 0x0020
(XSTAT_BT_CHANGE_REPLACERID))
slot=93 ridposn=0 oldposn=0
old ts=0x0000 0x00001cb0 new ts=0x0000 0x00001cb5
B-tree key:
1000325c060 ( 0): 003473c8 3f000000 00005220 17 .4s.?.....R .
BT_INSERT (256040,1) sessionid=256038,36
attcnt=1 rno=1 op=71 padlen=7 sessionid=256038,36 len=96
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
objid=28 syspartitions indid=4 ptnid=28 pageno=129 level=0 root=128 cid=
0
status=0x220 (0x0200 (XSTAT_BT_CHANGE_LCTXREPLACEDEL), 0x0020
(XSTAT_BT_CHANGE_REPLACERID))
slot=93 ridposn=0 oldposn=0
old ts=0x0000 0x00001cb1 new ts=0x0000 0x00001cb6
B-tree key:
1000325c0b0 ( 0): 013473c8 3f000000 00005220 170b745f .4s.?.....R ..t_
1000325c0c0 ( 16): 38383030 30333133 35 880003135
BT_DELETE (256040,2) sessionid=256038,36
attcnt=1 rno=2 op=72 padlen=7 sessionid=256038,36 len=96
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
objid=24 sysstatistics indid=2 ptnid=24 pageno=625 level=0 root=624 cid=
0
status=0x00 (0x0000)
slot=8 ridposn=0 oldposn=0
old ts=0x0000 0x00001c84 new ts=0x0000 0x00001cb7
B-tree key:
1000325c110 ( 0): 013473c8 3f000034 73c83f00 006c0000 .4s.?..4s.?..l..
1000325c120 ( 16): 00010000 01f10001 ff .........
DOL_DELETE (256040,3) sessionid=256038,36
attcnt=1 rno=3 op=66 padlen=4 sessionid=256038,36 len=160
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
objectid=24 sysstatistics ptnid=24 pageno=497 rowno=1 cid=0 erl=0
status (xstat)=0x1000 (0x1000 (XSTAT_DOL_EXROW))
old ts=0x0000 0x00001c83 new ts=0x0000 0x00001cb8
xdol_row:
1000325c162 ( 0): 00010000 00070000 00000000 3473c83f ............4s.?
1000325c172 ( 16): 3473c83f 00000000 00000000 00000001 4s.?............
1000325c182 ( 32): 00009d51 00d1a923 6c06006a 00000000 ...Q...#l..j....
1000325c192 ( 48): 00000000 00000000 00000000 40080000 ............@...
1000325c1a2 ( 64): 00000000 40000000 00000000 40000000 ....@.......@...
1000325c1b2 ( 80): 00000000 00000000 00000000 0054004c .............T.L
1000325c1c2 ( 96): 0044003c 0034002c 202c .D.<.4., ,
DOL_INSERT (256040,4) sessionid=256038,36
attcnt=1 rno=4 op=63 padlen=6 sessionid=256038,36 len=152
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
objectid=24 sysstatistics ptnid=24 pageno=497 rowno=6 cid=0 erl=0
status (xstat)=0x1000 (0x1000 (XSTAT_DOL_EXROW))
old ts=0x0000 0x00001cb8 new ts=0x0000 0x00001cb9
xdol_row:
1000325c202 ( 0): 00060004 00060000 00000000 3473c83f ............4s.?
1000325c212 ( 16): 3473c83f 00000000 00000000 00000001 4s.?............
1000325c222 ( 32): 00009d51 00d1a923 6c050060 00000000 ...Q...#l..`....
1000325c232 ( 48): 00000000 00000000 00000000 40000000 ............@...
1000325c242 ( 64): 00000000 40000000 00000000 40000000 ....@.......@...
1000325c252 ( 80): 00000000 004c0044 003c0034 002c202c .....L.D.<.4., ,
1000325c262 ( 96):
BT_INSERT (256040,5) sessionid=256038,36
attcnt=1 rno=5 op=71 padlen=7 sessionid=256038,36 len=96
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
objid=24 sysstatistics indid=2 ptnid=24 pageno=625 level=0 root=624 cid=
0
status=0x220 (0x0200 (XSTAT_BT_CHANGE_LCTXREPLACEDEL), 0x0020
(XSTAT_BT_CHANGE_REPLACERID))
slot=8 ridposn=0 oldposn=0
old ts=0x0000 0x00001cb7 new ts=0x0000 0x00001cba
B-tree key:
1000325c2a8 ( 0): 013473c8 3f000034 73c83f00 006c0000 .4s.?..4s.?..l..
1000325c2b8 ( 16): 00010000 01f12006 ff ...... ..
BT_DELETE (256040,6) sessionid=256038,36
attcnt=1 rno=6 op=72 padlen=3 sessionid=256038,36 len=80
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
objid=1 sysobjects indid=2 ptnid=1 pageno=161 level=0 root=160 cid=0
status=0x00 (0x0000)
slot=35 ridposn=0 oldposn=0
old ts=0x0000 0x00001c68 new ts=0x0000 0x00001cbb
B-tree key:
1000325c308 ( 0): 01000000 01000000 01201e01 74 ......... ..t
BT_DELETE (256040,7) sessionid=256038,36
attcnt=1 rno=7 op=72 padlen=5 sessionid=256038,36 len=80
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
objid=1 sysobjects indid=3 ptnid=1 pageno=10 level=0 root=9 cid=0 status
=0x00
(0x0000)
slot=48 ridposn=0 oldposn=0
old ts=0x0000 0x00001c69 new ts=0x0000 0x00001cbd
B-tree key:
1000325c358 ( 0): 003473c8 3f000000 01001e .4s.?......
DOL_UPDATE (256040,8) sessionid=256038,36
attcnt=1 rno=8 op=65 padlen=6 sessionid=256038,36 len=72
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
objectid=1 sysobjects ptnid=1 pageno=1 rowno=30 cid=0 erl=0
status (xstat)=0x1000 (0x1000 (XSTAT_DOL_EXROW))
status2 (xstat2)=0x00 (0x0000)
old ts=0x0000 0x00001ca6 new ts=0x0000 0x00001cbe
xfirstoff=82, xoldvlen=1, xnewvlen=1
xoldstatus=0x0c: (0x0008 (DOL_ROW_UPDATED), 0x0004 (DOL_ROW_POSSUNCMT))
xnewstatus=0x0c: (0x0008 (DOL_ROW_UPDATED), 0x0004 (DOL_ROW_POSSUNCMT))
old image: 4
1000325c3a8 ( 0): 04 .
new image: 0
1000325c3a9 ( 0): 00 .
BT_INSERT (256040,9) sessionid=256038,36
attcnt=1 rno=9 op=71 padlen=3 sessionid=256038,36 len=80
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
objid=1 sysobjects indid=2 ptnid=1 pageno=161 level=0 root=160 cid=0
status=0x20 (0x0020 (XSTAT_BT_CHANGE_REPLACERID))
slot=35 ridposn=0 oldposn=0
old ts=0x0000 0x00001cbb new ts=0x0000 0x00001cbf
B-tree key:
1000325c3f0 ( 0): 01000000 01000000 01201e01 74 ......... ..t
BT_INSERT (256040,10) sessionid=256038,36
attcnt=1 rno=10 op=71 padlen=5 sessionid=256038,36 len=80
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
objid=1 sysobjects indid=3 ptnid=1 pageno=10 level=0 root=9 cid=0 status
=0x20
(0x0020 (XSTAT_BT_CHANGE_REPLACERID))
slot=48 ridposn=0 oldposn=0
old ts=0x0000 0x00001cbd new ts=0x0000 0x00001cc0
B-tree key:
1000325c440 ( 0): 003473c8 3f000000 01201e .4s.?.... .
ENDXACT (256040,11) sessionid=256038,36
attcnt=1 rno=11 op=30 padlen=4 sessionid=256038,36 len=32
odc_stat=0x0000 (0x0000)
loh_status: 0x0 (0x00000000)
endstat=COMMIT time=Apr 7 2010 12:43:21:076PM
xstat=0x0 []
Total number of log records 301
DBCC execution completed. If DBCC printed error messages, contact a user with
System Administrator (SA) role.
有兴趣的可以自己分析一下。
自己先补充一下。
如果数据库没有打开select into选项的时候,drop column都会报错误:
Msg 11052, Level 16, State 1: Server 'TEST', Line 1: The 'select into' database option is not enabled for database 'escourt5'. ALTER TABLE with data copy cannot be done. Set the 'select into' database option and re-run 。
注意:不能添加非空列(除了第一个identity列)。 添加一列的时候,指定为非空并且有默认值的话,也报错:
1> alter table test add COLE char(1) default "0"
2> go
Msg 11052, Level 16, State 1: Server 'TEST', Line 1: The 'select into' database option is not enabled for database 'escourt5'. ALTER TABLE with data copy cannot be done. Set the 'select into' database option and re-run.
有空总结一下。 为什么会进行data copy。
————————————————————————————————-
—- 本文为andkylee个人原创,请在尊重作者劳动成果的前提下进行转载;
—- 转载务必注明原始出处 : http://www.dbainfo.net
—- 关键字: 字段 增加 删除 日志 内部 internals
————————————————————————————————-