Oracle logmnr簡單測試
1.檢視補充日誌資訊
select SUPPLEMENTAL_LOG_DATA_MIN min, SUPPLEMENTAL_LOG_DATA_PK pk, SUPPLEMENTAL_LOG_DATA_UI ui, SUPPLEMENTAL_LOG_DATA_FK fk, SUPPLEMENTAL_LOG_DATA_ALL "all" from v$database;
MIN PK UI FK all -------- --- --- --- --- NO NO NO NO NO
2.開啟最小補充日誌
alter database add supplemental log data;
對應告警日誌：
Thu Aug 26 17:02:19 2021 alter database add supplemental log data SUPLOG: Previous supplemental logging attributes at scn = 4987183 SUPLOG: minimal = OFF, primary key = OFF SUPLOG: unique = OFF, foreign key = OFF, all column = OFF SUPLOG: procedural replication = OFF SUPLOG: New supplemental logging attributes at scn = 4987183 SUPLOG: minimal = ON, primary key = OFF SUPLOG: unique = OFF, foreign key = OFF, all column = OFF SUPLOG: procedural replication = OFF Completed: alter database add supplemental log data
3.建立測試資料
conn test/test create table test1 as select level id,'a' as col1 from dual connect by level<=100; create table test2 as select * from test1; alter system switch logfile; truncate table test1; insert into test1 select * from test1; commit; alter system switch logfile;
4. 檢視歸檔資訊
SQL> ho ls /arch exam2_1_183_1075828699.arc exam2_1_184_1075828699.arc
5.日誌挖掘
SQL> EXECUTE DBMS_LOGMNR.ADD_LOGFILE(LogFileName=>'/arch/exam2_1_184_1075828699.arc',Options=>dbms_logmnr.new); ---追加 EXECUTE DBMS_LOGMNR.ADD_LOGFILE(LogFileName=>'/arch/exam2_1_144_1075828699.arc',Options=>dbms_logmnr.addfile); SQL> exec dbms_logmnr.start_logmnr(options=>dbms_logmnr.dict_from_online_catalog); SQL> create table test3 as select * from v$logmnr_contents; SQL> exec dbms_logmnr.end_logmnr;
6.檢視挖掘資料
select scn, timestamp, username, session#, serial#, sql_redo, sql_undo, operation from test3 where lower(sql_redo) like '%test1%';
SCNTIMESTAMPUSERNAMESESSION#SERIAL#SQL_REDOSQL_UNDOOPERATION
149912652021/8/26 17:28:43TEST38717893"truncate table test1;"DDL
249912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('1','a');delete from "TEST"."TEST1" where "ID" = '1' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAA';INSERT
349912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('2','a');delete from "TEST"."TEST1" where "ID" = '2' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAB';INSERT
449912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('3','a');delete from "TEST"."TEST1" where "ID" = '3' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAC';INSERT
549912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('4','a');delete from "TEST"."TEST1" where "ID" = '4' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAD';INSERT
649912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('5','a');delete from "TEST"."TEST1" where "ID" = '5' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAE';INSERT
749912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('6','a');delete from "TEST"."TEST1" where "ID" = '6' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAF';INSERT
849912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('7','a');delete from "TEST"."TEST1" where "ID" = '7' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAG';INSERT
949912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('8','a');delete from "TEST"."TEST1" where "ID" = '8' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAH';INSERT
1049912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('9','a');delete from "TEST"."TEST1" where "ID" = '9' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAI';INSERT
1149912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('10','a');delete from "TEST"."TEST1" where "ID" = '10' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAJ';INSERT
1249912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('11','a');delete from "TEST"."TEST1" where "ID" = '11' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAK';INSERT
1349912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('12','a');delete from "TEST"."TEST1" where "ID" = '12' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAL';INSERT
1449912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('13','a');delete from "TEST"."TEST1" where "ID" = '13' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAM';INSERT
1549912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('14','a');delete from "TEST"."TEST1" where "ID" = '14' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAN';INSERT
1649912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('15','a');delete from "TEST"."TEST1" where "ID" = '15' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAO';INSERT
1749912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('16','a');delete from "TEST"."TEST1" where "ID" = '16' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAP';INSERT
1849912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('17','a');delete from "TEST"."TEST1" where "ID" = '17' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAQ';INSERT
1949912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('18','a');delete from "TEST"."TEST1" where "ID" = '18' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAR';INSERT
2049912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('19','a');delete from "TEST"."TEST1" where "ID" = '19' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAS';INSERT
2149912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('20','a');delete from "TEST"."TEST1" where "ID" = '20' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAT';INSERT
2249912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('21','a');delete from "TEST"."TEST1" where "ID" = '21' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAU';INSERT
2349912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('22','a');delete from "TEST"."TEST1" where "ID" = '22' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAV';INSERT
2449912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('23','a');delete from "TEST"."TEST1" where "ID" = '23' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAW';INSERT
2549912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('24','a');delete from "TEST"."TEST1" where "ID" = '24' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAX';INSERT
2649912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('25','a');delete from "TEST"."TEST1" where "ID" = '25' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAY';INSERT
2749912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('26','a');delete from "TEST"."TEST1" where "ID" = '26' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAZ';INSERT
2849912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('27','a');delete from "TEST"."TEST1" where "ID" = '27' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAa';INSERT
2949912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('28','a');delete from "TEST"."TEST1" where "ID" = '28' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAb';INSERT
3049912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('29','a');delete from "TEST"."TEST1" where "ID" = '29' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAc';INSERT
3149912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('30','a');delete from "TEST"."TEST1" where "ID" = '30' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAd';INSERT
3249912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('31','a');delete from "TEST"."TEST1" where "ID" = '31' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAe';INSERT
3349912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('32','a');delete from "TEST"."TEST1" where "ID" = '32' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAf';INSERT
3449912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('33','a');delete from "TEST"."TEST1" where "ID" = '33' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAg';INSERT
3549912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('34','a');delete from "TEST"."TEST1" where "ID" = '34' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAh';INSERT
3649912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('35','a');delete from "TEST"."TEST1" where "ID" = '35' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAi';INSERT
3749912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('36','a');delete from "TEST"."TEST1" where "ID" = '36' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAj';INSERT
3849912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('37','a');delete from "TEST"."TEST1" where "ID" = '37' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAk';INSERT
3949912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('38','a');delete from "TEST"."TEST1" where "ID" = '38' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAl';INSERT
4049912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('39','a');delete from "TEST"."TEST1" where "ID" = '39' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAm';INSERT
4149912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('40','a');delete from "TEST"."TEST1" where "ID" = '40' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAn';INSERT
4249912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('41','a');delete from "TEST"."TEST1" where "ID" = '41' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAo';INSERT
4349912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('42','a');delete from "TEST"."TEST1" where "ID" = '42' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAp';INSERT
4449912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('43','a');delete from "TEST"."TEST1" where "ID" = '43' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAq';INSERT
4549912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('44','a');delete from "TEST"."TEST1" where "ID" = '44' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAr';INSERT
4649912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('45','a');delete from "TEST"."TEST1" where "ID" = '45' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAs';INSERT
4749912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('46','a');delete from "TEST"."TEST1" where "ID" = '46' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAt';INSERT
4849912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('47','a');delete from "TEST"."TEST1" where "ID" = '47' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAu';INSERT
4949912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('48','a');delete from "TEST"."TEST1" where "ID" = '48' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAv';INSERT
5049912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('49','a');delete from "TEST"."TEST1" where "ID" = '49' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAw';INSERT
5149912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('50','a');delete from "TEST"."TEST1" where "ID" = '50' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAx';INSERT
5249912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('51','a');delete from "TEST"."TEST1" where "ID" = '51' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAy';INSERT
5349912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('52','a');delete from "TEST"."TEST1" where "ID" = '52' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAAz';INSERT
5449912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('53','a');delete from "TEST"."TEST1" where "ID" = '53' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAA0';INSERT
5549912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('54','a');delete from "TEST"."TEST1" where "ID" = '54' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAA1';INSERT
5649912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('55','a');delete from "TEST"."TEST1" where "ID" = '55' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAA2';INSERT
5749912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('56','a');delete from "TEST"."TEST1" where "ID" = '56' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAA3';INSERT
5849912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('57','a');delete from "TEST"."TEST1" where "ID" = '57' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAA4';INSERT
5949912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('58','a');delete from "TEST"."TEST1" where "ID" = '58' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAA5';INSERT
6049912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('59','a');delete from "TEST"."TEST1" where "ID" = '59' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAA6';INSERT
6149912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('60','a');delete from "TEST"."TEST1" where "ID" = '60' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAA7';INSERT
6249912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('61','a');delete from "TEST"."TEST1" where "ID" = '61' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAA8';INSERT
6349912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('62','a');delete from "TEST"."TEST1" where "ID" = '62' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAA9';INSERT
6449912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('63','a');delete from "TEST"."TEST1" where "ID" = '63' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAA+';INSERT
6549912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('64','a');delete from "TEST"."TEST1" where "ID" = '64' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnAA/';INSERT
6649912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('65','a');delete from "TEST"."TEST1" where "ID" = '65' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnABA';INSERT
6749912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('66','a');delete from "TEST"."TEST1" where "ID" = '66' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnABB';INSERT
6849912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('67','a');delete from "TEST"."TEST1" where "ID" = '67' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnABC';INSERT
6949912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('68','a');delete from "TEST"."TEST1" where "ID" = '68' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnABD';INSERT
7049912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('69','a');delete from "TEST"."TEST1" where "ID" = '69' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnABE';INSERT
7149912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('70','a');delete from "TEST"."TEST1" where "ID" = '70' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnABF';INSERT
7249912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('71','a');delete from "TEST"."TEST1" where "ID" = '71' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnABG';INSERT
7349912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('72','a');delete from "TEST"."TEST1" where "ID" = '72' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnABH';INSERT
7449912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('73','a');delete from "TEST"."TEST1" where "ID" = '73' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnABI';INSERT
7549912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('74','a');delete from "TEST"."TEST1" where "ID" = '74' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnABJ';INSERT
7649912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('75','a');delete from "TEST"."TEST1" where "ID" = '75' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnABK';INSERT
7749912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('76','a');delete from "TEST"."TEST1" where "ID" = '76' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnABL';INSERT
7849912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('77','a');delete from "TEST"."TEST1" where "ID" = '77' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnABM';INSERT
7949912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('78','a');delete from "TEST"."TEST1" where "ID" = '78' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnABN';INSERT
8049912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('79','a');delete from "TEST"."TEST1" where "ID" = '79' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnABO';INSERT
8149912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('80','a');delete from "TEST"."TEST1" where "ID" = '80' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnABP';INSERT
8249912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('81','a');delete from "TEST"."TEST1" where "ID" = '81' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnABQ';INSERT
8349912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('82','a');delete from "TEST"."TEST1" where "ID" = '82' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnABR';INSERT
8449912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('83','a');delete from "TEST"."TEST1" where "ID" = '83' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnABS';INSERT
8549912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('84','a');delete from "TEST"."TEST1" where "ID" = '84' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnABT';INSERT
8649912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('85','a');delete from "TEST"."TEST1" where "ID" = '85' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnABU';INSERT
8749912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('86','a');delete from "TEST"."TEST1" where "ID" = '86' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnABV';INSERT
8849912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('87','a');delete from "TEST"."TEST1" where "ID" = '87' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnABW';INSERT
8949912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('88','a');delete from "TEST"."TEST1" where "ID" = '88' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnABX';INSERT
9049912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('89','a');delete from "TEST"."TEST1" where "ID" = '89' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnABY';INSERT
9149912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('90','a');delete from "TEST"."TEST1" where "ID" = '90' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnABZ';INSERT
9249912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('91','a');delete from "TEST"."TEST1" where "ID" = '91' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnABa';INSERT
9349912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('92','a');delete from "TEST"."TEST1" where "ID" = '92' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnABb';INSERT
9449912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('93','a');delete from "TEST"."TEST1" where "ID" = '93' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnABc';INSERT
9549912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('94','a');delete from "TEST"."TEST1" where "ID" = '94' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnABd';INSERT
9649912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('95','a');delete from "TEST"."TEST1" where "ID" = '95' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnABe';INSERT
9749912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('96','a');delete from "TEST"."TEST1" where "ID" = '96' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnABf';INSERT
9849912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('97','a');delete from "TEST"."TEST1" where "ID" = '97' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnABg';INSERT
9949912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('98','a');delete from "TEST"."TEST1" where "ID" = '98' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnABh';INSERT
10049912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('99','a');delete from "TEST"."TEST1" where "ID" = '99' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnABi';INSERT
10149912792021/8/26 17:29:03TEST38717893insert into "TEST"."TEST1"("ID","COL1") values ('100','a');delete from "TEST"."TEST1" where "ID" = '100' and "COL1" = 'a' and ROWID = 'AAAWGQAAEAACGqnABj';INSERT
#####chenjuchao 2021-08-26 18:50#####
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/29785807/viewspace-2789038/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- Oracle RAC的TAF簡單測試Oracle
- 關於oracle session的簡單測試OracleSession
- mysql簡單效能測試MySql
- sql trace 簡單測試SQL
- 【Oracle19c】Oracle19c rman使用簡單測試Oracle
- 使用python對oracle進行簡單效能測試PythonOracle
- ORACLE EBS 安裝後的簡單基本測試方法Oracle
- mysqlimport匯入簡單測試MySqlImport
- （一）Jmeter簡單介面測試JMeter
- Windows IO 效能簡單測試Windows
- Windows 10 TechPreview簡單測試WindowsView
- 簡單的 ping 測試
- Jmeter效能測試簡單使用JMeter
- oracle logmnrOracle
- 【PG效能測試】pgbench效能測試工具簡單使用
- 讓 API 測試變的簡單API
- Linux的OOMkiller簡單測試LinuxOOM
- index 包含null值得簡單測試IndexNull
- InnoSetup簡單教程一，安裝使用和簡單測試
- Oracle logmnr使用Oracle
- oracle logmnr文件Oracle
- 簡單的神經網路測試神經網路
- ios最簡單的測試打包方式iOS
- MySQL Profile在5.7的簡單測試MySql
- 閃迴歸檔的簡單測試
- pl/sql中的forall簡單測試SQL
- 簡單的hector連線casssandra測試
- 簡單的鍵值儲存測試
- Spring 測試：其實很簡單Spring
- 最簡單的jquery測試程式碼jQuery
- 如何寫好測試用例以及go單元測試工具testify簡單介紹Go
- Android單元測試-作用以及簡單示例Android
- 移動效能測試---工具PerfDog簡單使用
- 一個簡單的介面測試框架 demo框架
- MySQL索引條件下推的簡單測試MySql索引
- mongoDB的主從複製簡單測試MongoDB
- RAC負載均衡的簡單測試（三）負載
- RAC負載均衡的簡單測試（二）負載