本文通过logminer分析了在Oracle数据库中，使用truncate和delete删除大量数据时的效率差异。实验结果显示，truncate操作仅产生一条日志记录，而delete操作会为每条删除的数据产生日志，因此truncate在清空表数据时的效率显著高于delete。建议在需要高效删除表数据时使用truncate。
首先打开数据库的最小日志附加模式:
alter database add supplemental log data;
准备两张数据表:
create table t03 as select * from dba_objects;
create table t04 as select * from dba_objects;
下面我们通过logminer来分析truncate与delete在删除数据方面的效率(产生的日志越小，删除数据的效率越高)。
现在对表t03执行truncate操作，对表t04执行delete操作，然后通过logminer分析两种操作产生日志的大小：
Connected to Oracle Database 10g Enterprise Edition Release 10.2.0.1.0
Connected as SYS
SQL> execute dbms_logmnr.add_logfile(LogFileName => '/u02/oradata/C2155/redo01.log',Options => dbms_logmnr.NEW);
PL/SQL procedure successfully completed
SQL> execute dbms_logmnr.add_logfile(LogFileName => '/u02/oradata/C2155/redo02.log',Options => dbms_logmnr.ADDFILE);
PL/SQL procedure successfully completed
SQL> execute dbms_logmnr.add_logfile(LogFileName => '/u02/oradata/C2155/redo03.log',Options => dbms_logmnr.ADDFILE);
PL/SQL procedure successfully completed
SQL> execute dbms_logmnr.start_logmnr(Options => dbms_logmnr.DICT_FROM_ONLINE_CATALOG);
PL/SQL procedure successfully completed
SQL> select * from v$logmnr_contents where table_name='T03';
SCN CSCN TIMESTAMP COMMIT_TIMESTAMP THREAD# LOG_ID XIDUSN XIDSLT XIDSQN PXIDUSN PXIDSLT PXIDSQN RBASQN RBABLK RBABYTE UBAFIL UBABLK UBAREC UBASQN ABS_FILE# REL_FILE# DATA_BLK# DATA_OBJ# DATA_OBJD# SEG_OWNER SEG_NAME TABLE_NAME SEG_TYPE SEG_TYPE_NAME TABLE_SPACE ROW_ID SESSION# SERIAL# USERNAME SESSION_INFO TX_NAME ROLLBACK OPERATION OPERATION_CODE SQL_REDO SQL_UNDO RS_ID SEQUENCE# SSN CSF INFO STATUS REDO_VALUE UNDO_VALUE SQL_COLUMN_TYPE SQL_COLUMN_NAME REDO_LENGTH REDO_OFFSET UNDO_LENGTH UNDO_OFFSET DATA_OBJV# SAFE_RESUME_SCN XID PXID AUDIT_SESSIONID
---------- ---------- ----------- ---------------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- -------------------------------- -------------------------------------------------------------------------------- -------------------------------- ---------- -------------------------------- -------------------------------- ------------------ ---------- ---------- ------------------------------ -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ---------- -------------------------------- -------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------- ---------- ---------- ---------- -------------------------------- ---------- ---------- ---------- ------------------------------ ------------------------------ ----------- ----------- ----------- ----------- ---------- --------------- ---------------- ---------------- ---------------
376280 2012-10-22 1 49 4 23 229 4 23 229 49 161 16 2 0 0 0 0 0 0 51183 0 DOLPHIN T03 T03 2 TABLE AAAAAAAAAAAAAAAAAB 1076 66 0 DDL 5 truncate table t03 0x000031.000000a1.0010 1 0 0 USER DDL (PlSql=0 RecDep=0) 0 160 161 0 0 0 0 1 04001700E5000000 04001700E5000000 84
此时我们可以发现执行truncate语句，仅产生一条日志记录。
SQL> select * from v$logmnr_contents where table_name='T04';
SCN CSCN TIMESTAMP COMMIT_TIMESTAMP THREAD# LOG_ID XIDUSN XIDSLT XIDSQN PXIDUSN PXIDSLT PXIDSQN RBASQN RBABLK RBABYTE UBAFIL UBABLK UBAREC UBASQN ABS_FILE# REL_FILE# DATA_BLK# DATA_OBJ# DATA_OBJD# SEG_OWNER SEG_NAME TABLE_NAME SEG_TYPE SEG_TYPE_NAME TABLE_SPACE ROW_ID SESSION# SERIAL# USERNAME SESSION_INFO TX_NAME ROLLBACK OPERATION OPERATION_CODE SQL_REDO SQL_UNDO RS_ID SEQUENCE# SSN CSF INFO STATUS REDO_VALUE UNDO_VALUE SQL_COLUMN_TYPE SQL_COLUMN_NAME REDO_LENGTH REDO_OFFSET UNDO_LENGTH UNDO_OFFSET DATA_OBJV# SAFE_RESUME_SCN XID PXID AUDIT_SESSIONID
---------- ---------- ----------- ---------------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- -------------------------------- -------------------------------------------------------------------------------- -------------------------------- ---------- -------------------------------- -------------------------------- ------------------ ---------- ---------- ------------------------------ -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ---------- -------------------------------- -------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------- ---------- ---------- ---------- -------------------------------- ---------- ---------- ---------- ------------------------------ ------------------------------ ----------- ----------- ----------- ----------- ---------- --------------- ---------------- ---------------- ---------------
376357 2012-10-22 1 49 6 16 214 6 16 214 49 264 16 2 0 0 0 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAA 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'ICOL$' an insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.00000108.0010 1 0 0 2 100272 100273 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 265 96 2 8412134 29 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAB 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'I_USER1' insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.00000109.0060 1 0 0 2 100274 100275 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 265 468 2 8412134 30 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAC 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'CON$' and insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.00000109.01d4 1 0 0 2 100276 100277 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 266 340 2 8412134 31 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAD 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'UNDO$' an insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.0000010a.0154 1 0 0 2 100278 100279 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 267 216 2 8412134 32 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAE 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'C_COBJ#' insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.0000010b.00d8 1 0 0 2 100280 100281 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 268 92 2 8412134 33 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAF 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'I_OBJ#' a insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.0000010c.005c 1 0 0 2 100282 100283 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 268 464 2 8412134 34 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAG 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'PROXY_ROL insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.0000010c.01d0 1 0 0 2 100284 100285 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 269 348 2 8412134 35 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAH 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'I_IND1' a insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.0000010d.015c 1 0 0 2 100286 100287 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 270 224 2 8412134 36 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAI 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'I_CDEF2' insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.0000010e.00e0 1 0 0 2 100288 100289 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 271 100 2 8412134 37 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAJ 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'I_PROXY_R insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.0000010f.0064 1 0 0 2 100290 100291 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 271 484 2 8412134 38 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAK 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'FILE$' an insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.0000010f.01e4 1 0 0 2 100292 100293 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 272 360 2 8412134 39 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAL 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'UET$' and insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.00000110.0168 1 0 0 2 100294 100295 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 273 232 2 8412134 40 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAM 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'I_FILE#_B insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.00000111.00e8 1 0 0 2 100296 100297 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 274 116 2 8412134 41 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAN 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'I_FILE1' insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.00000112.0074 1 0 0 2 100298 100299 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 274 488 2 8412134 42 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAO 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'I_CON1' a insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.00000112.01e8 1 0 0 2 100300 100301 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 275 364 2 8412134 43 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAP 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'I_OBJ3' a insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.00000113.016c 1 0 0 2 100302 100303 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 276 412 2 8412136 1 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAQ 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'I_TS#' an insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.00000114.019c 1 0 0 2 100304 100305 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 277 288 2 8412136 2 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAR 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'I_CDEF4' insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.00000115.0120 1 0 0 2 100306 100307 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 278 164 2 8412136 3 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAS 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'IND$' and insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.00000116.00a4 1 0 0 2 100308 100309 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 279 36 2 8412136 4 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAT 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'SEG$' and insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.00000117.0024 1 0 0 2 100310 100311 0 0 0 0 1 06001000D6000000 06001000D6000000 84
SCN CSCN TIMESTAMP COMMIT_TIMESTAMP THREAD# LOG_ID XIDUSN XIDSLT XIDSQN PXIDUSN PXIDSLT PXIDSQN RBASQN RBABLK RBABYTE UBAFIL UBABLK UBAREC UBASQN ABS_FILE# REL_FILE# DATA_BLK# DATA_OBJ# DATA_OBJD# SEG_OWNER SEG_NAME TABLE_NAME SEG_TYPE SEG_TYPE_NAME TABLE_SPACE ROW_ID SESSION# SERIAL# USERNAME SESSION_INFO TX_NAME ROLLBACK OPERATION OPERATION_CODE SQL_REDO SQL_UNDO RS_ID SEQUENCE# SSN CSF INFO STATUS REDO_VALUE UNDO_VALUE SQL_COLUMN_TYPE SQL_COLUMN_NAME REDO_LENGTH REDO_OFFSET UNDO_LENGTH UNDO_OFFSET DATA_OBJV# SAFE_RESUME_SCN XID PXID AUDIT_SESSIONID
---------- ---------- ----------- ---------------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- -------------------------------- -------------------------------------------------------------------------------- -------------------------------- ---------- -------------------------------- -------------------------------- ------------------ ---------- ---------- ------------------------------ -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ---------- -------------------------------- -------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------- ---------- ---------- ---------- -------------------------------- ---------- ---------- ---------- ------------------------------ ------------------------------ ----------- ----------- ----------- ----------- ---------- --------------- ---------------- ---------------- ---------------
376357 2012-10-22 1 49 6 16 214 6 16 214 49 279 404 2 8412136 5 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAU 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'C_TS#' an insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.00000117.0194 1 0 0 2 100312 100313 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 280 280 2 8412136 6 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAV 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'I_FILE2' insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.00000118.0118 1 0 0 2 100314 100315 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 281 156 2 8412136 7 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAW 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'COL$' and insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.00000119.009c 1 0 0 2 100316 100317 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 282 28 2 8412136 8 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAX 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'I_TS1' an insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.0000011a.001c 1 0 0 2 100318 100319 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 282 400 2 8412136 9 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAY 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'I_UNDO2' insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.0000011a.0190 1 0 0 2 100320 100321 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 283 276 2 8412136 10 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAZ 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'CLU$' and insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.0000011b.0114 1 0 0 2 100322 100323 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 284 148 2 8412136 11 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAa 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'PROXY_DAT insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.0000011c.0094 1 0 0 2 100324 100325 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 285 28 2 8412136 12 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAb 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'I_PROXY_D insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.0000011d.001c 1 0 0 2 100326 100327 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 285 408 2 8412136 13 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAc 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'I_OBJ1' a insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.0000011d.0198 1 0 0 2 100328 100329 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 286 284 2 8412136 14 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAd 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'I_COL2' a insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.0000011e.011c 1 0 0 2 100330 100331 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 287 160 2 8412136 15 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAe 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'I_OBJ2' a insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.0000011f.00a0 1 0 0 2 100332 100333 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 288 36 2 8412136 16 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAf 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'I_CCOL1' insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.00000120.0024 1 0 0 2 100334 100335 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 288 408 2 8412136 17 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAg 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'TS$' and insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.00000120.0198 1 0 0 2 100336 100337 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 289 280 2 8412136 18 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAh 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'C_FILE#_B insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.00000121.0118 1 0 0 2 100338 100339 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 290 164 2 8412136 19 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAi 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'C_USER#' insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.00000122.00a4 1 0 0 2 100340 100341 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 291 40 2 8412136 20 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAj 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'I_UNDO1' insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.00000123.0028 1 0 0 2 100342 100343 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 291 412 2 8412136 21 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAk 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'BOOTSTRAP insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.00000123.019c 1 0 0 2 100344 100345 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 292 292 2 8412136 22 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAl 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'FET$' and insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.00000124.0124 1 0 0 2 100346 100347 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 293 164 2 8412136 23 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAm 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'I_TAB1' a insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.00000125.00a4 1 0 0 2 100348 100349 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 294 40 2 8412136 24 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAn 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'CCOL$' an insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.00000126.0028 1 0 0 2 100350 100351 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 294 412 2 8412136 25 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAo 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'USER$' an insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.00000126.019c 1 0 0 2 100352 100353 0 0 0 0 1 06001000D6000000 06001000D6000000 84
SCN CSCN TIMESTAMP COMMIT_TIMESTAMP THREAD# LOG_ID XIDUSN XIDSLT XIDSQN PXIDUSN PXIDSLT PXIDSQN RBASQN RBABLK RBABYTE UBAFIL UBABLK UBAREC UBASQN ABS_FILE# REL_FILE# DATA_BLK# DATA_OBJ# DATA_OBJD# SEG_OWNER SEG_NAME TABLE_NAME SEG_TYPE SEG_TYPE_NAME TABLE_SPACE ROW_ID SESSION# SERIAL# USERNAME SESSION_INFO TX_NAME ROLLBACK OPERATION OPERATION_CODE SQL_REDO SQL_UNDO RS_ID SEQUENCE# SSN CSF INFO STATUS REDO_VALUE UNDO_VALUE SQL_COLUMN_TYPE SQL_COLUMN_NAME REDO_LENGTH REDO_OFFSET UNDO_LENGTH UNDO_OFFSET DATA_OBJV# SAFE_RESUME_SCN XID PXID AUDIT_SESSIONID
---------- ---------- ----------- ---------------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- -------------------------------- -------------------------------------------------------------------------------- -------------------------------- ---------- -------------------------------- -------------------------------- ------------------ ---------- ---------- ------------------------------ -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ---------- -------------------------------- -------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------- ---------- ---------- ---------- -------------------------------- ---------- ---------- ---------- ------------------------------ ------------------------------ ----------- ----------- ----------- ----------- ---------- --------------- ---------------- ---------------- ---------------
376357 2012-10-22 1 49 6 16 214 6 16 214 49 295 288 2 8412136 26 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAp 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'I_CON2' a insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.00000127.0120 1 0 0 2 100354 100355 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 296 164 2 8412136 27 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAq 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'I_COBJ#' insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.00000128.00a4 1 0 0 2 100356 100357 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 297 152 2 8412136 28 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAr 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'OBJ$' and insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.00000129.0098 1 0 0 2 100358 100359 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 298 24 2 8412136 29 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAs 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'I_COL3' a insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.0000012a.0018 1 0 0 2 100360 100361 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 298 396 2 8412136 30 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAt 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'C_OBJ#' a insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.0000012a.018c 1 0 0 2 100362 100363 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 299 272 2 8412136 31 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAu 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'TAB$' and insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.0000012b.0110 1 0 0 2 100364 100365 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 300 144 2 8412136 32 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAv 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'CDEF$' an insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.0000012c.0090 1 0 0 2 100366 100367 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 301 20 2 8412136 33 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAw 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'I_CDEF1' insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.0000012d.0014 1 0 0 2 100368 100369 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 301 392 2 8412136 34 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAx 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'I_ICOL1' insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.0000012d.0188 1 0 0 2 100370 100371 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 302 328 2 8412137 1 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAy 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'I_CDEF3' insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.0000012e.0148 1 0 0 2 100372 100373 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 303 204 2 8412137 2 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAz 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'I_CCOL2' insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.0000012f.00cc 1 0 0 2 100374 100375 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 304 80 2 8412137 3 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAA0 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'I_COL1' a insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.00000130.0050 1 0 0 2 100376 100377 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 304 452 2 8412137 4 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAA1 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'I_USER#' insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.00000130.01c4 1 0 0 2 100378 100379 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 305 328 2 8412137 5 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAA2 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'I_PROXY_R insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.00000131.0148 1 0 0 2 100380 100381 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 306 216 2 8412137 6 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAA3 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'OBJAUTH$' insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.00000132.00d8 1 0 0 2 100382 100383 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 307 92 2 8412137 7 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAA4 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'UGROUP$' insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.00000133.005c 1 0 0 2 100384 100385 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 307 464 2 8412137 8 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAA5 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'I_UGROUP1 insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.00000133.01d0 1 0 0 2 100386 100387 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 308 344 2 8412137 9 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAA6 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'I_UGROUP2 insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.00000134.0158 1 0 0 2 100388 100389 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 309 224 2 8412137 10 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAA7 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'TSQ$' and insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.00000135.00e0 1 0 0 2 100390 100391 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 310 96 2 8412137 11 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAA8 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'SYN$' and insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.00000136.0060 1 0 0 2 100392 100393 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 310 464 2 8412137 12 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAA9 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'VIEW$' an insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.00000136.01d0 1 0 0 2 100394 100395 0 0 0 0 1 06001000D6000000 06001000D6000000 84
...............................
...............................
...............................
由此，我们发现，一旦所要清空的表数据量非常大，delete产生的日志是相当客观的。因此我们可以说，使用truncate清空表比delete清空表的效率要高的多。
alter database add supplemental log data;
准备两张数据表:
create table t03 as select * from dba_objects;
create table t04 as select * from dba_objects;
下面我们通过logminer来分析truncate与delete在删除数据方面的效率(产生的日志越小，删除数据的效率越高)。
现在对表t03执行truncate操作，对表t04执行delete操作，然后通过logminer分析两种操作产生日志的大小：
Connected to Oracle Database 10g Enterprise Edition Release 10.2.0.1.0
Connected as SYS
SQL> execute dbms_logmnr.add_logfile(LogFileName => '/u02/oradata/C2155/redo01.log',Options => dbms_logmnr.NEW);
PL/SQL procedure successfully completed
SQL> execute dbms_logmnr.add_logfile(LogFileName => '/u02/oradata/C2155/redo02.log',Options => dbms_logmnr.ADDFILE);
PL/SQL procedure successfully completed
SQL> execute dbms_logmnr.add_logfile(LogFileName => '/u02/oradata/C2155/redo03.log',Options => dbms_logmnr.ADDFILE);
PL/SQL procedure successfully completed
SQL> execute dbms_logmnr.start_logmnr(Options => dbms_logmnr.DICT_FROM_ONLINE_CATALOG);
PL/SQL procedure successfully completed
SQL> select * from v$logmnr_contents where table_name='T03';
SCN CSCN TIMESTAMP COMMIT_TIMESTAMP THREAD# LOG_ID XIDUSN XIDSLT XIDSQN PXIDUSN PXIDSLT PXIDSQN RBASQN RBABLK RBABYTE UBAFIL UBABLK UBAREC UBASQN ABS_FILE# REL_FILE# DATA_BLK# DATA_OBJ# DATA_OBJD# SEG_OWNER SEG_NAME TABLE_NAME SEG_TYPE SEG_TYPE_NAME TABLE_SPACE ROW_ID SESSION# SERIAL# USERNAME SESSION_INFO TX_NAME ROLLBACK OPERATION OPERATION_CODE SQL_REDO SQL_UNDO RS_ID SEQUENCE# SSN CSF INFO STATUS REDO_VALUE UNDO_VALUE SQL_COLUMN_TYPE SQL_COLUMN_NAME REDO_LENGTH REDO_OFFSET UNDO_LENGTH UNDO_OFFSET DATA_OBJV# SAFE_RESUME_SCN XID PXID AUDIT_SESSIONID
---------- ---------- ----------- ---------------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- -------------------------------- -------------------------------------------------------------------------------- -------------------------------- ---------- -------------------------------- -------------------------------- ------------------ ---------- ---------- ------------------------------ -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ---------- -------------------------------- -------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------- ---------- ---------- ---------- -------------------------------- ---------- ---------- ---------- ------------------------------ ------------------------------ ----------- ----------- ----------- ----------- ---------- --------------- ---------------- ---------------- ---------------
376280 2012-10-22 1 49 4 23 229 4 23 229 49 161 16 2 0 0 0 0 0 0 51183 0 DOLPHIN T03 T03 2 TABLE AAAAAAAAAAAAAAAAAB 1076 66 0 DDL 5 truncate table t03 0x000031.000000a1.0010 1 0 0 USER DDL (PlSql=0 RecDep=0) 0 160 161 0 0 0 0 1 04001700E5000000 04001700E5000000 84
此时我们可以发现执行truncate语句，仅产生一条日志记录。
SQL> select * from v$logmnr_contents where table_name='T04';
SCN CSCN TIMESTAMP COMMIT_TIMESTAMP THREAD# LOG_ID XIDUSN XIDSLT XIDSQN PXIDUSN PXIDSLT PXIDSQN RBASQN RBABLK RBABYTE UBAFIL UBABLK UBAREC UBASQN ABS_FILE# REL_FILE# DATA_BLK# DATA_OBJ# DATA_OBJD# SEG_OWNER SEG_NAME TABLE_NAME SEG_TYPE SEG_TYPE_NAME TABLE_SPACE ROW_ID SESSION# SERIAL# USERNAME SESSION_INFO TX_NAME ROLLBACK OPERATION OPERATION_CODE SQL_REDO SQL_UNDO RS_ID SEQUENCE# SSN CSF INFO STATUS REDO_VALUE UNDO_VALUE SQL_COLUMN_TYPE SQL_COLUMN_NAME REDO_LENGTH REDO_OFFSET UNDO_LENGTH UNDO_OFFSET DATA_OBJV# SAFE_RESUME_SCN XID PXID AUDIT_SESSIONID
---------- ---------- ----------- ---------------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- -------------------------------- -------------------------------------------------------------------------------- -------------------------------- ---------- -------------------------------- -------------------------------- ------------------ ---------- ---------- ------------------------------ -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ---------- -------------------------------- -------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------- ---------- ---------- ---------- -------------------------------- ---------- ---------- ---------- ------------------------------ ------------------------------ ----------- ----------- ----------- ----------- ---------- --------------- ---------------- ---------------- ---------------
376357 2012-10-22 1 49 6 16 214 6 16 214 49 264 16 2 0 0 0 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAA 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'ICOL$' an insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.00000108.0010 1 0 0 2 100272 100273 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 265 96 2 8412134 29 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAB 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'I_USER1' insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.00000109.0060 1 0 0 2 100274 100275 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 265 468 2 8412134 30 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAC 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'CON$' and insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.00000109.01d4 1 0 0 2 100276 100277 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 266 340 2 8412134 31 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAD 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'UNDO$' an insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.0000010a.0154 1 0 0 2 100278 100279 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 267 216 2 8412134 32 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAE 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'C_COBJ#' insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.0000010b.00d8 1 0 0 2 100280 100281 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 268 92 2 8412134 33 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAF 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'I_OBJ#' a insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.0000010c.005c 1 0 0 2 100282 100283 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 268 464 2 8412134 34 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAG 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'PROXY_ROL insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.0000010c.01d0 1 0 0 2 100284 100285 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 269 348 2 8412134 35 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAH 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'I_IND1' a insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.0000010d.015c 1 0 0 2 100286 100287 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 270 224 2 8412134 36 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAI 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'I_CDEF2' insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.0000010e.00e0 1 0 0 2 100288 100289 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 271 100 2 8412134 37 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAJ 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'I_PROXY_R insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.0000010f.0064 1 0 0 2 100290 100291 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 271 484 2 8412134 38 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAK 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'FILE$' an insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.0000010f.01e4 1 0 0 2 100292 100293 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 272 360 2 8412134 39 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAL 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'UET$' and insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.00000110.0168 1 0 0 2 100294 100295 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 273 232 2 8412134 40 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAM 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'I_FILE#_B insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.00000111.00e8 1 0 0 2 100296 100297 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 274 116 2 8412134 41 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAN 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'I_FILE1' insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.00000112.0074 1 0 0 2 100298 100299 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 274 488 2 8412134 42 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAO 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'I_CON1' a insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.00000112.01e8 1 0 0 2 100300 100301 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 275 364 2 8412134 43 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAP 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'I_OBJ3' a insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.00000113.016c 1 0 0 2 100302 100303 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 276 412 2 8412136 1 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAQ 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'I_TS#' an insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.00000114.019c 1 0 0 2 100304 100305 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 277 288 2 8412136 2 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAR 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'I_CDEF4' insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.00000115.0120 1 0 0 2 100306 100307 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 278 164 2 8412136 3 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAS 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'IND$' and insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.00000116.00a4 1 0 0 2 100308 100309 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 279 36 2 8412136 4 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAT 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'SEG$' and insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.00000117.0024 1 0 0 2 100310 100311 0 0 0 0 1 06001000D6000000 06001000D6000000 84
SCN CSCN TIMESTAMP COMMIT_TIMESTAMP THREAD# LOG_ID XIDUSN XIDSLT XIDSQN PXIDUSN PXIDSLT PXIDSQN RBASQN RBABLK RBABYTE UBAFIL UBABLK UBAREC UBASQN ABS_FILE# REL_FILE# DATA_BLK# DATA_OBJ# DATA_OBJD# SEG_OWNER SEG_NAME TABLE_NAME SEG_TYPE SEG_TYPE_NAME TABLE_SPACE ROW_ID SESSION# SERIAL# USERNAME SESSION_INFO TX_NAME ROLLBACK OPERATION OPERATION_CODE SQL_REDO SQL_UNDO RS_ID SEQUENCE# SSN CSF INFO STATUS REDO_VALUE UNDO_VALUE SQL_COLUMN_TYPE SQL_COLUMN_NAME REDO_LENGTH REDO_OFFSET UNDO_LENGTH UNDO_OFFSET DATA_OBJV# SAFE_RESUME_SCN XID PXID AUDIT_SESSIONID
---------- ---------- ----------- ---------------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- -------------------------------- -------------------------------------------------------------------------------- -------------------------------- ---------- -------------------------------- -------------------------------- ------------------ ---------- ---------- ------------------------------ -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ---------- -------------------------------- -------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------- ---------- ---------- ---------- -------------------------------- ---------- ---------- ---------- ------------------------------ ------------------------------ ----------- ----------- ----------- ----------- ---------- --------------- ---------------- ---------------- ---------------
376357 2012-10-22 1 49 6 16 214 6 16 214 49 279 404 2 8412136 5 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAU 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'C_TS#' an insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.00000117.0194 1 0 0 2 100312 100313 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 280 280 2 8412136 6 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAV 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'I_FILE2' insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.00000118.0118 1 0 0 2 100314 100315 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 281 156 2 8412136 7 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAW 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'COL$' and insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.00000119.009c 1 0 0 2 100316 100317 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 282 28 2 8412136 8 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAX 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'I_TS1' an insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.0000011a.001c 1 0 0 2 100318 100319 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 282 400 2 8412136 9 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAY 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'I_UNDO2' insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.0000011a.0190 1 0 0 2 100320 100321 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 283 276 2 8412136 10 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAZ 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'CLU$' and insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.0000011b.0114 1 0 0 2 100322 100323 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 284 148 2 8412136 11 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAa 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'PROXY_DAT insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.0000011c.0094 1 0 0 2 100324 100325 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 285 28 2 8412136 12 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAb 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'I_PROXY_D insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.0000011d.001c 1 0 0 2 100326 100327 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 285 408 2 8412136 13 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAc 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'I_OBJ1' a insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.0000011d.0198 1 0 0 2 100328 100329 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 286 284 2 8412136 14 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAd 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'I_COL2' a insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.0000011e.011c 1 0 0 2 100330 100331 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 287 160 2 8412136 15 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAe 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'I_OBJ2' a insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.0000011f.00a0 1 0 0 2 100332 100333 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 288 36 2 8412136 16 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAf 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'I_CCOL1' insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.00000120.0024 1 0 0 2 100334 100335 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 288 408 2 8412136 17 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAg 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'TS$' and insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.00000120.0198 1 0 0 2 100336 100337 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 289 280 2 8412136 18 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAh 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'C_FILE#_B insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.00000121.0118 1 0 0 2 100338 100339 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 290 164 2 8412136 19 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAi 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'C_USER#' insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.00000122.00a4 1 0 0 2 100340 100341 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 291 40 2 8412136 20 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAj 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'I_UNDO1' insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.00000123.0028 1 0 0 2 100342 100343 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 291 412 2 8412136 21 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAk 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'BOOTSTRAP insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.00000123.019c 1 0 0 2 100344 100345 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 292 292 2 8412136 22 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAl 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'FET$' and insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.00000124.0124 1 0 0 2 100346 100347 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 293 164 2 8412136 23 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAm 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'I_TAB1' a insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.00000125.00a4 1 0 0 2 100348 100349 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 294 40 2 8412136 24 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAn 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'CCOL$' an insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.00000126.0028 1 0 0 2 100350 100351 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 294 412 2 8412136 25 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAo 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'USER$' an insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.00000126.019c 1 0 0 2 100352 100353 0 0 0 0 1 06001000D6000000 06001000D6000000 84
SCN CSCN TIMESTAMP COMMIT_TIMESTAMP THREAD# LOG_ID XIDUSN XIDSLT XIDSQN PXIDUSN PXIDSLT PXIDSQN RBASQN RBABLK RBABYTE UBAFIL UBABLK UBAREC UBASQN ABS_FILE# REL_FILE# DATA_BLK# DATA_OBJ# DATA_OBJD# SEG_OWNER SEG_NAME TABLE_NAME SEG_TYPE SEG_TYPE_NAME TABLE_SPACE ROW_ID SESSION# SERIAL# USERNAME SESSION_INFO TX_NAME ROLLBACK OPERATION OPERATION_CODE SQL_REDO SQL_UNDO RS_ID SEQUENCE# SSN CSF INFO STATUS REDO_VALUE UNDO_VALUE SQL_COLUMN_TYPE SQL_COLUMN_NAME REDO_LENGTH REDO_OFFSET UNDO_LENGTH UNDO_OFFSET DATA_OBJV# SAFE_RESUME_SCN XID PXID AUDIT_SESSIONID
---------- ---------- ----------- ---------------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- -------------------------------- -------------------------------------------------------------------------------- -------------------------------- ---------- -------------------------------- -------------------------------- ------------------ ---------- ---------- ------------------------------ -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ---------- -------------------------------- -------------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- -------------------------------- ---------- ---------- ---------- -------------------------------- ---------- ---------- ---------- ------------------------------ ------------------------------ ----------- ----------- ----------- ----------- ---------- --------------- ---------------- ---------------- ---------------
376357 2012-10-22 1 49 6 16 214 6 16 214 49 295 288 2 8412136 26 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAp 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'I_CON2' a insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.00000127.0120 1 0 0 2 100354 100355 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 296 164 2 8412136 27 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAq 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'I_COBJ#' insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.00000128.00a4 1 0 0 2 100356 100357 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 297 152 2 8412136 28 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAr 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'OBJ$' and insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.00000129.0098 1 0 0 2 100358 100359 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 298 24 2 8412136 29 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAs 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'I_COL3' a insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.0000012a.0018 1 0 0 2 100360 100361 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 298 396 2 8412136 30 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAt 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'C_OBJ#' a insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.0000012a.018c 1 0 0 2 100362 100363 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 299 272 2 8412136 31 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAu 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'TAB$' and insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.0000012b.0110 1 0 0 2 100364 100365 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 300 144 2 8412136 32 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAv 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'CDEF$' an insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.0000012c.0090 1 0 0 2 100366 100367 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 301 20 2 8412136 33 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAw 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'I_CDEF1' insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.0000012d.0014 1 0 0 2 100368 100369 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 301 392 2 8412136 34 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAx 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'I_ICOL1' insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.0000012d.0188 1 0 0 2 100370 100371 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 302 328 2 8412137 1 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAy 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'I_CDEF3' insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.0000012e.0148 1 0 0 2 100372 100373 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 303 204 2 8412137 2 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAAz 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'I_CCOL2' insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.0000012f.00cc 1 0 0 2 100374 100375 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 304 80 2 8412137 3 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAA0 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'I_COL1' a insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.00000130.0050 1 0 0 2 100376 100377 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 304 452 2 8412137 4 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAA1 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'I_USER#' insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.00000130.01c4 1 0 0 2 100378 100379 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 305 328 2 8412137 5 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAA2 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'I_PROXY_R insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.00000131.0148 1 0 0 2 100380 100381 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 306 216 2 8412137 6 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAA3 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'OBJAUTH$' insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.00000132.00d8 1 0 0 2 100382 100383 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 307 92 2 8412137 7 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAA4 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'UGROUP$' insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.00000133.005c 1 0 0 2 100384 100385 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 307 464 2 8412137 8 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAA5 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'I_UGROUP1 insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.00000133.01d0 1 0 0 2 100386 100387 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 308 344 2 8412137 9 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAA6 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'I_UGROUP2 insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.00000134.0158 1 0 0 2 100388 100389 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 309 224 2 8412137 10 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAA7 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'TSQ$' and insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.00000135.00e0 1 0 0 2 100390 100391 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 310 96 2 8412137 11 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAA8 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'SYN$' and insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.00000136.0060 1 0 0 2 100392 100393 0 0 0 0 1 06001000D6000000 06001000D6000000 84
376357 2012-10-22 1 49 6 16 214 6 16 214 49 310 464 2 8412137 12 76 2 5 12 51184 51184 DOLPHIN T04 T04 2 TABLE CHENT AAAMfwAAFAAAAAMAA9 1076 66 0 DELETE 2 delete from "DOLPHIN"."T04" where "OWNER" = 'SYS' and "OBJECT_NAME" = 'VIEW$' an insert into "DOLPHIN"."T04"("OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID"," 0x000031.00000136.01d0 1 0 0 2 100394 100395 0 0 0 0 1 06001000D6000000 06001000D6000000 84
...............................
...............................
...............................
由此，我们发现，一旦所要清空的表数据量非常大，delete产生的日志是相当客观的。因此我们可以说，使用truncate清空表比delete清空表的效率要高的多。
扫一扫
3146
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
