Yong Huang 发表于 2011-12-15 04:28
Can you also check XIDUSN and XIDSLT? If they're not the same for both SCN 616667 and 616688, then X ...
谢谢回复。
supplemental logging选项是打开了的。
加入了XIDUSN和XIDSLT之后的日志如下:
6 1 616666 345 START 0 0 SYS AAAAAAAAAAAAAAAAAA
6 1 616666 345 DELETE 3 23848 SYS AAAMNKAADAAAF0oAAB
XIDUSN XIDSLT SCN XIDSQN OPERATION REL_FILE# DATA_BLK# USERNAME ROW_ID
---------- ---------- ---------- ---------- -------------------------------- ---------- ---------- ------------------------------ ------------------
6 1 616666 345 INTERNAL 0 0 SYS AAAMU6AAAAAAAAAAAA
6 1 616666 345 INTERNAL 0 0 SYS AAAMU7AAAAAAAAAAAA
6 1 616666 345 INSERT 3 23840 SYS AAAMNJAADAAAF0gAAC
6 1 616667 345 COMMIT 0 0 SYS AAAAAAAAAAAAAAAAAA
5 33 616668 349 START 0 0 SYS AAAAAAAAAAAAAAAAAA
5 33 616668 349 UPDATE 0 0 SYS AAAMUBAAAAAAAAAAAA
5 33 616668 349 UPDATE 3 27222 SYS AAAMT+AADAAAGpWAAK
5 33 616668 349 UPDATE 3 27222 SYS AAAMT+AADAAAGpWAAK
5 33 616669 349 ROLLBACK 0 0 SYS AAAAAAAAAAAAAAAAAA
7 29 616670 320 START 0 0 SYS AAAAAAAAAAAAAAAAAA
7 29 616670 320 UPDATE 0 0 SYS AAAMUBAAAAAAAAAAAA
XIDUSN XIDSLT SCN XIDSQN OPERATION REL_FILE# DATA_BLK# USERNAME ROW_ID
---------- ---------- ---------- ---------- -------------------------------- ---------- ---------- ------------------------------ ------------------
7 29 616670 320 UPDATE 3 27222 SYS AAAMT+AADAAAGpWAAL
7 29 616670 320 UPDATE 3 27222 SYS AAAMT+AADAAAGpWAAL
7 29 616671 320 ROLLBACK 0 0 SYS AAAAAAAAAAAAAAAAAA
10 23 616672 315 START 0 0 SYS AAAAAAAAAAAAAAAAAA
10 23 616672 315 INSERT 3 26936 SYS AAAMTZAADAAAGk4AAE
10 23 616673 315 COMMIT 0 0 SYS AAAAAAAAAAAAAAAAAA
9 3 616680 352 START 0 0 AAAAAAAAAAAAAAAAAA
9 3 616680 352 UPDATE 3 25936 AAAMRaAADAAAGVQAAB
9 3 616681 352 COMMIT 0 0 AAAAAAAAAAAAAAAAAA
3 35 616683 321 START 0 0 SYS AAAAAAAAAAAAAAAAAA
3 35 616683 321 UPDATE 1 1658 SYS AAAADtAABAAAAZ6AAA
XIDUSN XIDSLT SCN XIDSQN OPERATION REL_FILE# DATA_BLK# USERNAME ROW_ID
---------- ---------- ---------- ---------- -------------------------------- ---------- ---------- ------------------------------ ------------------
3 35 616684 321 COMMIT 0 0 SYS AAAAAAAAAAAAAAAAAA
8 29 616686 348 START 0 0 SYSMAN AAAAAAAAAAAAAAAAAA
8 29 616686 348 UPDATE 3 27092 SYSMAN AAAMTuAADAAAGnUAAA
8 29 616687 348 COMMIT 0 0 SYSMAN AAAAAAAAAAAAAAAAAA
6 16 616688 345 START 0 0 SYSMAN AAAAAAAAAAAAAAAAAA
6 16 616688 345 INSERT 3 26934 SYSMAN AAAMTZAADAAAGk2ABc
6 16 616689 345 COMMIT 0 0 SYSMAN AAAAAAAAAAAAAAAAAA
可以看出两个345对应的XIDSLT并不相同,那么在Oracle里面到底什么东西可以用来唯一的标识一个事务呢?