20230614-2

最新推荐文章于 2026-06-15 19:25:03 发布

原创最新推荐文章于 2026-06-15 19:25:03 发布 · 123 阅读

0 ·

本内容遵循CC 4.0 BY-SA版权协议

select count(*) from

select * from dba_directories ;

DATA_PUMP_DIR

select count(*) from

select * from dba_users ;

DATA_PUMP_DIR

CREATE OR REPLACE DIRECTORY tmp_dir AS '/home/oracle/tmp_dir';

2、赋权：

GRANT READ,WRITE ON DIRECTORY tmp_dir TO tbcs0522;
c

select dbms_random.string('a',20)||trunc(dbms_random.value(0,10)) from dual

insert into test75008 select dbms_random.string('a',20) from test75001 where rownum<1000000;
commit;

select count(*) from test75001
select 52*52*52 from dual

select trunc(dbms_random.value(0,10)) from dual

drop table test75001

create table test75001 as select id from test75004

insert into test75001 select * from test75001 ;
commit;

select 2000000000*22/100000/84000 from dual

dbms_random.string('a',20)

select '
update /*+append*/ test7400w set ab3=null where MOD(ab4,1000)=9;
commit;
',rownum from test75001 where rownum <1000

select * from dba_data_files;

dbms_random.value*10000000000000000 as ab1 ,
dbms_random.string('a',20) as ab2 ,
sysdate-dbms_random.value as ab3 ,
trunc(dbms_Random.Value(0, 10000000)) as ab4 ,
sysdate-dbms_random.value*30 as ab5 ,
dbms_random.string('a',4) as ab6 ,
dbms_random.string('a',4)||trunc(dbms_random.value(0,10)) as ab7 ,
dbms_random.string('a',3) as ab8

select count(*) from test7400w

create index idx_ab2_74w on test7400w(ab2);

insert into /*+append*/ test7400w nologging
select
trunc(dbms_Random.Value(0, 740000000)) as ab1 ,
trunc(dbms_Random.Value(0, 7400000)) as ab2 ,
trunc(dbms_Random.Value(0, 74000000)) as ab3 ,
trunc(dbms_Random.Value(0, 740000)) as ab4 ,
dbms_random.string('a',4) as ab5 ,
dbms_random.string('a',4) as ab6 ,
dbms_random.string('a',4) as ab7 ,
dbms_random.string('a',32) as ab8 ,
dbms_random.string('a',1) as ab9 ,
trunc(dbms_Random.Value(0, 740000)) as ab10 ,
dbms_random.string('a',32) as ab11 ,
trunc(dbms_Random.Value(0, 740000)) as ab12 ,
trunc(dbms_Random.Value(0, 7400000)) as ab13 ,
trunc(dbms_Random.Value(0, 7400000)) as ab14 ,
dbms_random.string('a',5) as ab15 ,
trunc(dbms_Random.Value(0, 7400000)) as ab16 ,
sysdate-dbms_random.value*30 as ab17 ,
sysdate-dbms_random.value*30 as ab18 ,
dbms_random.string('a',4) as ab19 ,
trunc(dbms_Random.Value(0, 7400000)) as ab20 ,
dbms_random.string('a',2) as ab21 ,
sysdate-dbms_random.value*365 as ab22 ,
'testtesttesttesttesttest' as ab23 ,
sysdate-dbms_random.value*365*3 as ab24 ,
sysdate-dbms_random.value*365*10 as ab25 ,
'testtesttesttesttest' as ab26 ,
'testtesttesttesttest' as ab27 ,
'testtesttesttesttest' as ab28 ,
'testtesttesttesttest' as ab29 ,
'testtesttesttesttest' as ab30 ,
'testtesttesttesttest' as ab31 ,
'testtesttesttesttest' as ab32 ,
'testtesttesttesttest' as ab33 ,
'testtesttesttesttest' as ab34 ,
'testtesttesttesttest' as ab35 from test75004 where rownum <=74000000 ;
commit;

create index idxtest7400w_ab4_mod200 on test7400w(mod(ab4,20));
--analyze table test75004 compute statistics;
analyze table test7400w compute statistics for all indexes;

update /*+append*/ test7400w nologging set ab3=null where MOD(ab1,20)=9;
commit;
update /*+append*/ test7400w nologging set ab3=null where MOD(ab2,20)=8;
commit;
update /*+append*/ test7400w nologging set ab3=null where MOD(ab3,20)=3;
commit;
update /*+append*/ test7400w nologging set ab4=null where MOD(ab4,20)=12;
commit;
update /*+append*/ test7400w nologging set ab5=null where MOD(ab5,20)=15;
commit;

analyze table test7400w compute statistics for all indexes;

select * from v$session;

select dbms_random.value*10000000000000000 as ab1 ,
dbms_random.string('a',20) as ab2 ,
sysdate-dbms_random.value as ab3 ,
trunc(dbms_Random.Value(0, 10000000)) as ab4 ,
sysdate-dbms_random.value*30 as ab5 ,
dbms_random.string('a',4) as ab6 ,
dbms_random.string('a',4)||trunc(dbms_random.value(0,10)) as ab7 ,
dbms_random.string('a',3) as ab8 ,
'testtesttesttesttesttest' as ab9 ,
'testtesttesttesttesttest' as ab10 ,
'testtesttesttesttesttest' as ab11 ,
'testtesttesttesttesttest' as ab12 ,
'testtesttesttesttesttest' as ab13 ,
'testtesttesttesttesttest' as ab14 ,
'testtesttesttesttesttest' as ab15 ,
'testtesttesttesttesttest' as ab16 ,
'testtesttesttesttesttest' as ab17 ,
'testtesttesttesttesttest' as ab18 ,
'testtesttesttesttesttest' as ab19 ,
'testtesttesttesttesttest' as ab20 ,
'testtesttesttesttesttest' as ab21 ,
'testtesttesttesttesttest' as ab22 ,
'testtesttesttesttesttest' as ab23 ,
'testtesttesttesttesttest' as ab24 ,
'testtesttesttesttesttest' as ab25 ,
'testtesttesttesttesttest' as ab26 ,
'testtesttesttesttesttest' as ab27 ,
'testtesttesttesttesttest' as ab28 ,
'testtesttesttesttesttest' as ab29 ,
'testtesttesttesttesttest' as ab30 ,
'testtesttesttesttesttest' as ab31 ,
'testtesttesttesttesttest' as ab32 ,
'testtesttesttesttesttest' as ab33 ,
'testtesttesttesttesttest' as ab34 ,
'testtesttesttesttesttest' as ab35 from dual

select count(*) from test75004

select Utl_Raw.Cast_To_Raw(sys.dbms_obfuscation_toolkit.md5(input_string => '123456')) from dual

select Utl_Raw.Cast_To_Raw(sys.dbms_obfuscation_toolkit.md5(input_string => ab2)) from tbcs0522.test75004 where MOD(ab4,20)=9

select ab2,Utl_Raw.Cast_To_Raw(sys.dbms_obfuscation_toolkit.md5(input_string => ab7)),Utl_Raw.Cast_To_Raw(sys.dbms_obfuscation_toolkit.md5(input_string => ab2))
from tbcs0522.test75004 where ab7='ojWY'

update /*+append*/ test75004 set ab3=null where MOD(ab4,1000)=9;
commit;
update /*+append*/ test75004 set ab4=null where MOD(ab4,20)=12;
commit;
update /*+append*/ test75004 set ab5=null where MOD(ab4,20)=15;
commit;

select trunc(dbms_Random.Value(0, 1000)) from dual

create index idx_74w_ab1 on test7400w(MOD(ab1,1000));
drop index

update /*+append*/ test7400w nologging set ab6=null where MOD(ab4,1000)=trunc(dbms_Random.Value(0, 1000));
commit;

select Dbms_rowid.rowid_object(rowid),
dbms_rowid.rowid_relative_fno (rowid),
dbms_rowid.rowid_block_number (rowid),
dbms_rowid.rowid_row_number (rowid),
ORA_ROWSCN,t.*
from test7400w t where rowid='AAAWuAAARAAGs2DAAB'

update test7400w t set where rowid='AAAWuAAARAAGs2DAAB'
SELECT SCN_TO_TIMESTAMP(1234567890) FROM dual;
SELECT SCN_TO_TIMESTAMP(78343981) FROM dual;

SELECT dbms_flashback.check_retention_target FROM dual WHERE dbms_flashback.check_scn(78343981) = 1;

SELECT SEQUENCE#, FIRST_TIME, NEXT_TIME
FROM V$ARCHIVED_LOG
ORDER BY SEQUENCE#;

SELECT CURRENT_SCN, SYSTIMESTAMP FROM V$DATABASE;

create index idx_rowscn_74w on test7400w(ORA_ROWSCN)

SELECT SCN_TO_TIMESTAMP(ora_rowscn) AS commit_time FROM <your_table_name>;

select to_char(SCN_TO_TIMESTAMP(ora_rowscn),'yyyymmdd hh24:mi:ssxff3'),ora_rowscn
from test7400w t where rowid<'AAAWuAAARAAGs2DAAB'

select dbms_flashback.get_system_change_number,SCN_TO_TIMESTAMP(dbms_flashback.get_system_change_number) scn from dual

SELECT sysdate,systimestamp,to_char(SCN_TO_TIMESTAMP(dbms_flashback.get_system_change_number),'yyyymmdd hh24:mi:ssxff3') FROM dual

show parameter db_flashback_retention_target

78345164
78345217

select ORA_ROWSCN from test7400w t where rowid<'AAAWuAAARAAGs2DAAB'

Dbms_rowid.rowid_object(rowid) 得到该行的对象号

dbms_rowid.rowid_relative_fno (rowid) rfile# 得到该行的文件号

dbms_rowid.rowid_block_number (rowid) block# 得到该行所在块号

dbms_rowid.rowid_row_number (rowid) row#, 等到该行的行号

dbms_rowid.rowid_to_absolute_fno (rowid,'SYS','TEST') file#

SELECT DBMS_BLOCK_MONITOR.GET_BLOCK_INFO('tbcs0522.test7400w', 10)
FROM DUAL;
select * from dba_views where view_name='V$BACKUP_BLOCK_CHANGE_TRACKING'
select * from v$backup_block_change_tracking
SELECT * FROM dba_tab_privs WHERE table_name = 'V$BACKUP_BLOCK_CHANGE_TRACKING';

SELECT * FROM dba_objects WHERE object_name = 'GET_CHANGE_SET';

SELECT * FROM TABLE(DBMS_BACKUP_RESTORE.GET_CHANGE_SET('bct_backup'));

SELECT * FROM v$block_change_tracking;
SELECT * FROM dba_objects WHERE object_name = 'DBMS_BACKUP_RESTORE' AND object_type = 'PACKAGE';

SELECT UTL_RAW.CAST_TO_RAW(ab1||ab2||ab3||ab4||ab5||ab6||ab7||ab8||ab9||ab10||ab11||ab12||ab13||ab14||ab15||ab16||ab17||ab18||ab19||ab20||ab21||ab22||ab23||ab24||ab25||ab26||ab27||ab28||ab29||ab30||ab31||ab32||ab33||ab34||ab35) FROM test7400w where rownum <10

insert into /*+append*/ test7400 select 1 as ab1 ,
'testtsttest' as ab2 ,
NULL as ab3 ,
10000000 as ab4 ,
NULL as ab5 ,
NULL as ab6 ,
'testtesttesttesttesttest' as ab7 ,
'testtesttesttesttesttest' as ab8 ,
'testtesttesttesttesttest' as ab9 ,
'testtesttesttesttesttest' as ab10 ,
'testtesttesttesttesttest' as ab11 ,
'testtesttesttesttesttest' as ab12 ,
'testtesttesttesttesttest' as ab13 ,
'testtesttesttesttesttest' as ab14 ,
'testtesttesttesttesttest' as ab15 ,
'testtesttesttesttesttest' as ab16 ,
'testtesttesttesttesttest' as ab17 ,
'testtesttesttesttesttest' as ab18 ,
'testtesttesttesttesttest' as ab19 ,
'testtesttesttesttesttest' as ab20 ,
'testtesttesttesttesttest' as ab21 ,
'testtesttesttesttesttest' as ab22 ,
'testtesttesttesttesttest' as ab23 ,
'testtesttesttesttesttest' as ab24 ,
'testtesttesttesttesttest' as ab25 ,
'testtesttesttesttesttest' as ab26 ,
'testtesttesttesttesttest' as ab27 ,
'testtesttesttesttesttest' as ab28 ,
'testtesttesttesttesttest' as ab29 ,
'testtesttesttesttesttest' as ab30 ,
'testtesttesttesttesttest' as ab31 ,
'' as ab32 ,
'' as ab33 ,
'' as ab34 ,
'' as ab35 from test75001 where rownum <100000;
commit;

SELECT COUNT(*) FROM test75001

select to_char(id) ,
ab2 ,
to_char(ab3,'yyyy-MM-dd HH24:mi:ss') ab3 ,
ab4 ,
to_char(ab5,'yyyy-MM-dd HH24:mi:ss') ab5
from test75004 where rownum<100

select sysdate from dual
analyze table test7400w compute statistics ;

select * from ( select rownum as rm, to_char(id) ,
ab2 ,
to_char(ab3,'yyyy-MM-dd HH24:mi:ss') ab3 ,
ab4 ,
to_char(ab5,'yyyy-MM-dd HH24:mi:ss') ab5 ,ab6,'select id,ab2,ab3,ab4,ab5,ab6,ab7,ab8,ab9,ab10,ab11,ab12,ab13,ab14,ab15,ab16,ab17,ab18,
ab19,ab20,ab21,ab22,ab23,ab24,ab25,ab26,ab27,ab28,ab29,ab30,ab31,ab32,ab33,ab34,ab35 from test75004
where id= '||to_char(id)||' and
ab2 = '''||ab2||''' and
ab3 = to_date('''||to_char(ab3,'yyyy-MM-dd HH24:mi:ss')||''',''yyyy-MM-dd HH24:mi:ss'') and
ab4 = '||ab4||' and
ab5 = to_date('''||to_char(ab5,'yyyy-MM-dd HH24:mi:ss')||''',''yyyy-MM-dd HH24:mi:ss'') and
ab6 = '''||ab6||''' and
ab7 = '''||ab7||''' and
ab8 = ''testtesttesttesttesttest'' and
ab9 = ''testtesttesttesttesttest'' and
ab10 = ''testtesttesttesttesttest'' and
ab11 = ''testtesttesttesttesttest'' and
ab12 = ''testtesttesttesttesttest'' and
ab13 = ''testtesttesttesttesttest'' and
ab14 = ''testtesttesttesttesttest'' and
ab15 = ''testtesttesttesttesttest'' and
ab16 = ''testtesttesttesttesttest'' and
ab17 = ''testtesttesttesttesttest'' and
ab18 = ''testtesttesttesttesttest'' and
ab19 = ''testtesttesttesttesttest'' and
ab20 = ''testtesttesttesttesttest'' and
ab21 = ''testtesttesttesttesttest'' and
ab22 = ''testtesttesttesttesttest'' and
ab23 = ''testtesttesttesttesttest'' and
ab24 = ''testtesttesttesttesttest'' and
ab25 = ''testtesttesttesttesttest'' and
ab26 = ''testtesttesttesttesttest'' and
ab27 = ''testtesttesttesttesttest'' and
ab28 = ''testtesttesttesttesttest'' and
ab29 = ''testtesttesttesttesttest'' and
ab30 = ''testtesttesttesttesttest'' and
ab31 = ''testtesttesttesttesttest'' and
ab32 is null and
ab33 is null and
ab34 is null and
ab35 is null ;'
from test75004
where ab2 is not null and
ab3 is not null and
ab4 is not null and
ab5 is not null and
id is not null and
rownum<17000) where rm >16000

select * from SP_WORKF_COMM order by workf_seq for update

select count(*) from SP_WORKF_COMM order by workf_seq

select * from (select
t.*,rownum rn from (select "workf_seq" as "columnName" from "tbcs"."sp_workf_comm" where "workf_seq" is null order by "workf_seq") t where rownum<=1) where rn>1-1

select * from v$version

select * from ( select rownum as rm, to_char(id) ,
ab2 ,
to_char(ab3,'yyyy-MM-dd HH24:mi:ss') ab3 ,
ab4 ,
to_char(ab5,'yyyy-MM-dd HH24:mi:ss') ab5 ,ab6,'select Utl_Raw.Cast_To_Raw(sys.dbms_obfuscation_toolkit.md5(input_string => id||ab2||ab3||ab4||ab5||ab6||ab7||ab8||ab9||ab10||ab11||ab12||ab13||ab14||ab15||ab16||ab17||ab18||ab19||ab20||ab21||ab22||ab23||ab24||ab25||ab26||ab27||ab28||ab29||ab30||ab31||ab32||ab33||ab34||ab35)) from test75004
where id= '||to_char(id)||' and
ab2 = '''||ab2||''' and
ab3 = to_date('''||to_char(ab3,'yyyy-MM-dd HH24:mi:ss')||''',''yyyy-MM-dd HH24:mi:ss'') and
ab4 = '||ab4||' and
ab5 = to_date('''||to_char(ab5,'yyyy-MM-dd HH24:mi:ss')||''',''yyyy-MM-dd HH24:mi:ss'') and
ab6 = '''||ab6||''' and
ab7 = '''||ab7||''' and
ab8 = ''testtesttesttesttesttest'' and
ab9 = ''testtesttesttesttesttest'' and
ab10 = ''testtesttesttesttesttest'' and
ab11 = ''testtesttesttesttesttest'' and
ab12 = ''testtesttesttesttesttest'' and
ab13 = ''testtesttesttesttesttest'' and
ab14 = ''testtesttesttesttesttest'' and
ab15 = ''testtesttesttesttesttest'' and
ab16 = ''testtesttesttesttesttest'' and
ab17 = ''testtesttesttesttesttest'' and
ab18 = ''testtesttesttesttesttest'' and
ab19 = ''testtesttesttesttesttest'' and
ab20 = ''testtesttesttesttesttest'' and
ab21 = ''testtesttesttesttesttest'' and
ab22 = ''testtesttesttesttesttest'' and
ab23 = ''testtesttesttesttesttest'' and
ab24 = ''testtesttesttesttesttest'' and
ab25 = ''testtesttesttesttesttest'' and
ab26 = ''testtesttesttesttesttest'' and
ab27 = ''testtesttesttesttesttest'' and
ab28 = ''testtesttesttesttesttest'' and
ab29 = ''testtesttesttesttesttest'' and
ab30 = ''testtesttesttesttesttest'' and
ab31 = ''testtesttesttesttesttest'' and
ab32 is null and
ab33 is null and
ab34 is null and
ab35 is null ;'
from test75004
where ab2 is not null and
ab3 is not null and
ab4 is not null and
ab5 is not null and
id is not null and
rownum<27000) where rm >26000

select * from dba_data_files;

ab3 = to_date('''||to_char(ab3,'yyyy-MM-dd HH24:mi:ss')||''',''yyyy-MM-dd HH24:mi:ss'') and

select t.* from ( select rownum as rm,ab3, ab6,ab8, 'select ab1,ab2,ab3,ab4,ab5,ab6,ab7,ab8,ab9,ab10,ab11,ab12,ab13,ab14,ab15,ab16,ab17,ab18,
ab19,ab20,ab21,ab22,ab23,ab24,ab25,ab26,ab27,ab28,ab29,ab30,ab31,ab32,ab33,ab34,ab35 from test7400w
where ab1= '||ab1||' and
ab2 = '||ab2||' and
ab3 '||NVL2( ab3,'='|| ab3||'', ' is null ') ||' and
ab4 = '||ab4||' and
ab5 = '''||ab5||''' and
ab6 '||NVL2( ab6,'='''|| ab6||'''', ' is null ') ||' and
ab7 = '''||ab7||''' and
ab8 '||NVL2( ab8,'='''|| ab8||'''', ' is null ') ||' and
ab9 = '''||ab9||''' and
ab10 = '||ab10||' and
ab11 = '''||ab11||''' and
ab12 = '||ab12||' and
ab13 = '||ab13||' and
ab14 = '||ab14||' and
ab15 = '''||ab15||''' and
ab16 = '||ab16||' and
ab17 = to_date('''||to_char(ab17,'yyyy-MM-dd HH24:mi:ss')||''',''yyyy-MM-dd HH24:mi:ss'') and
ab18 = to_date('''||to_char(ab18,'yyyy-MM-dd HH24:mi:ss')||''',''yyyy-MM-dd HH24:mi:ss'') and
ab19 = '''||ab19||''' and
ab20 = '||ab20||' and
ab21 = '''||ab21||''' and
ab22 = to_date('''||to_char(ab22,'yyyy-MM-dd HH24:mi:ss')||''',''yyyy-MM-dd HH24:mi:ss'') and
ab23 = ''testtesttesttesttesttest'' and
ab24 = to_date('''||to_char(ab24,'yyyy-MM-dd HH24:mi:ss')||''',''yyyy-MM-dd HH24:mi:ss'') and
ab25 = to_date('''||to_char(ab25,'yyyy-MM-dd HH24:mi:ss')||''',''yyyy-MM-dd HH24:mi:ss'') and
ab26 = ''testtesttesttesttest'' and
ab27 = ''testtesttesttesttest'' and
ab28 = ''testtesttesttesttest'' and
ab29 = ''testtesttesttesttest'' and
ab30 = ''testtesttesttesttest'' and
ab31 = ''testtesttesttesttest'' and
ab32 = ''testtesttesttesttest'' and
ab33 = ''testtesttesttesttest'' and
ab34 = ''testtesttesttesttest'' and
ab35 = ''testtesttesttesttest''
;'
from test7400w
where
rownum<300000 ) t where rm >20000

set feedback off
set pagesize 0
set head off
set line 180
set timing off
set echo off
spool 26.log

spool off

drop index IDX_AB2_74W

create index IDX_AB5_74W on test7400w(ab5);

select ab6,t.* from ( select rownum as rm, ab6,ab8,ab3, 'select ab1,ab2,ab3,ab4,ab5,ab6,ab7,ab8,ab9,ab10,ab11,ab12,ab13,ab14,ab15,ab16,ab17,ab18,
ab19,ab20,ab21,ab22,ab23,ab24,ab25,ab26,ab27,ab28,ab29,ab30,ab31,ab32,ab33,ab34,ab35 from test7400w
where ab1= '||ab1||' and
ab2 = '||ab2||' and
nvl(ab3,''null'') '||NVL2( ab3,'='''|| ab3||'''', '= ''null''') ||' and

ab4 = '||ab4||' and
ab5 = '''||ab5||''' and
nvl(ab6,''null'') '||NVL2( ab6,'='''|| ab6||'''', '= ''null''') ||' and
ab7 = '''||ab7||''' and
nvl(ab8,''null'') '||NVL2( ab8,'='''|| ab8||'''', '= ''null''') ||' and
ab9 = '''||ab9||''' and
ab10 = '||ab10||' and
ab11 = '''||ab11||''' and
ab12 = '||ab12||' and
ab13 = '||ab13||' and
ab14 = '||ab14||' and
ab15 = '''||ab15||''' and
ab16 = '||ab16||' and
ab17 = to_date('''||to_char(ab17,'yyyy-MM-dd HH24:mi:ss')||''',''yyyy-MM-dd HH24:mi:ss'') and
ab18 = to_date('''||to_char(ab18,'yyyy-MM-dd HH24:mi:ss')||''',''yyyy-MM-dd HH24:mi:ss'') and
ab19 = '''||ab19||''' and
ab20 = '||ab20||' and
ab21 = '''||ab21||''' and
ab22 = to_date('''||to_char(ab22,'yyyy-MM-dd HH24:mi:ss')||''',''yyyy-MM-dd HH24:mi:ss'') and
ab23 = ''testtesttesttesttesttest'' and
ab24 = to_date('''||to_char(ab24,'yyyy-MM-dd HH24:mi:ss')||''',''yyyy-MM-dd HH24:mi:ss'') and
ab25 = to_date('''||to_char(ab25,'yyyy-MM-dd HH24:mi:ss')||''',''yyyy-MM-dd HH24:mi:ss'') and
ab26 = ''testtesttesttesttest'' and
ab27 = ''testtesttesttesttest'' and
ab28 = ''testtesttesttesttest'' and
ab29 = ''testtesttesttesttest'' and
ab30 = ''testtesttesttesttest'' and
ab31 = ''testtesttesttesttest'' and
ab32 = ''testtesttesttesttest'' and
ab33 = ''testtesttesttesttest'' and
ab34 = ''testtesttesttesttest'' and
ab35 = ''testtesttesttesttest''
;'
from test7400w
where
rownum<14000 and ( ab6 is not null or ab8 is not null) ) t where rm >13000

select t.* from ( select rownum as rm,ab3, ab6,ab8, 'select ab1,ab2,ab3,ab4,ab5,ab6,ab7,ab8,ab9,ab10,ab11,ab12,ab13,ab14,ab15,ab16,ab17,ab18,
ab19,ab20,ab21,ab22,ab23,ab24,ab25,ab26,ab27,ab28,ab29,ab30,ab31,ab32,ab33,ab34,ab35 from test500w
where ab1= '||ab1||' and
ab2 = '||ab2||' and
ab3 '||NVL2( ab3,'='|| ab3||'', ' is null ') ||' and
ab4 = '||ab4||' and
ab5 = '''||ab5||''' and
ab6 '||NVL2( ab6,'='''|| ab6||'''', ' is null ') ||' and
ab7 = '''||ab7||''' and
ab8 '||NVL2( ab8,'='''|| ab8||'''', ' is null ') ||' and
ab9 = '''||ab9||''' and
ab10 = '||ab10||' and
ab11 = '''||ab11||''' and
ab12 = '||ab12||' and
ab13 = '||ab13||' and
ab14 = '||ab14||' and
ab15 = '''||ab15||''' and
ab16 = '||ab16||' and
ab17 = to_date('''||to_char(ab17,'yyyy-MM-dd HH24:mi:ss')||''',''yyyy-MM-dd HH24:mi:ss'') and
ab18 = to_date('''||to_char(ab18,'yyyy-MM-dd HH24:mi:ss')||''',''yyyy-MM-dd HH24:mi:ss'') and
ab19 = '''||ab19||''' and
ab20 = '||ab20||' and
ab21 = '''||ab21||''' and
ab22 = to_date('''||to_char(ab22,'yyyy-MM-dd HH24:mi:ss')||''',''yyyy-MM-dd HH24:mi:ss'') and
ab23 = ''testtesttesttesttesttest'' and
ab24 = to_date('''||to_char(ab24,'yyyy-MM-dd HH24:mi:ss')||''',''yyyy-MM-dd HH24:mi:ss'') and
ab25 = to_date('''||to_char(ab25,'yyyy-MM-dd HH24:mi:ss')||''',''yyyy-MM-dd HH24:mi:ss'') and
ab26 = ''testtesttesttesttest'' and
ab27 = ''testtesttesttesttest'' and
ab28 = ''testtesttesttesttest'' and
ab29 = ''testtesttesttesttest'' and
ab30 = ''testtesttesttesttest'' and
ab31 = ''testtesttesttesttest'' and
ab32 = ''testtesttesttesttest'' and
ab33 = ''testtesttesttesttest'' and
ab34 = ''testtesttesttesttest'' and
ab35 = ''testtesttesttesttest''
;'
from test500w
where
rownum<9000 ) t where rm >8000

select * from ( select rownum as rm, to_char(id) ,
ab2 ,
to_char(ab3,'yyyy-MM-dd HH24:mi:ss') ab3 ,
ab4 ,
to_char(ab5,'yyyy-MM-dd HH24:mi:ss') ab5 ,ab6,'select Utl_Raw.Cast_To_Raw(sys.dbms_obfuscation_toolkit.md5(input_string => id||ab2||ab3||ab4||ab5||ab6||ab7||ab8||ab9||ab10||ab11||ab12||ab13||ab14||ab15||ab16||ab17||ab18||ab19||ab20||ab21||ab22||ab23||ab24||ab25||ab26||ab27||ab28||ab29||ab30||ab31||ab32||ab33||ab34||ab35)) from test75004
where id= '||to_char(id)||' and
ab2 = '''||ab2||''' and
ab3 = to_date('''||to_char(ab3,'yyyy-MM-dd HH24:mi:ss')||''',''yyyy-MM-dd HH24:mi:ss'') and
ab4 = '||ab4||' and
ab5 = to_date('''||to_char(ab5,'yyyy-MM-dd HH24:mi:ss')||''',''yyyy-MM-dd HH24:mi:ss'') and
ab6 = '''||ab6||''' and
ab7 = '''||ab7||''' and
ab8 = ''testtesttesttesttesttest'' and
ab9 = ''testtesttesttesttesttest'' and
ab10 = ''testtesttesttesttesttest'' and
ab11 = ''testtesttesttesttesttest'' and
ab12 = ''testtesttesttesttesttest'' and
ab13 = ''testtesttesttesttesttest'' and
ab14 = ''testtesttesttesttesttest'' and
ab15 = ''testtesttesttesttesttest'' and
ab16 = ''testtesttesttesttesttest'' and
ab17 = ''testtesttesttesttesttest'' and
ab18 = ''testtesttesttesttesttest'' and
ab19 = ''testtesttesttesttesttest'' and
ab20 = ''testtesttesttesttesttest'' and
ab21 = ''testtesttesttesttesttest'' and
ab22 = ''testtesttesttesttesttest'' and
ab23 = ''testtesttesttesttesttest'' and
ab24 = ''testtesttesttesttesttest'' and
ab25 = ''testtesttesttesttesttest'' and
ab26 = ''testtesttesttesttesttest'' and
ab27 = ''testtesttesttesttesttest'' and
ab28 = ''testtesttesttesttesttest'' and
ab29 = ''testtesttesttesttesttest'' and
ab30 = ''testtesttesttesttesttest'' and
ab31 = ''testtesttesttesttesttest'' and
ab32 is null and
ab33 is null and
ab34 is null and
ab35 is null ;'
from test75004
where ab2 is not null and
ab3 is not null and
ab4 is not null and
ab5 is not null and
id is not null and
rownum<27000) where rm >26000

select COMPONENT,CURRENT_SIZE/1024/1024||'MB' MB from V$SGA_DYNAMIC_COMPONENTS where COMPONENT in ('DEFAULT buffer cache','KEEP buffer cache');
create index idxtest75004_ab5 on test75004(ab5);

select bytes/1024/1024 from dba_segments where segment_name='IDXTEST75004_AB5'

3776 3968
alter system set db_keep_cache_size=8G;

select p.name,a.cnum_repl "total buffers",a.anum_repl "free buffers" from x$kcbwds a, v$buffer_pool p where a.set_id=p.LO_SETID and p.name='KEEP';

ALTER INDEX IDXTEST75004_AB5 STORAGE (BUFFER_POOL KEEP);
ALTER INDEX IDXTEST75004_AB7 STORAGE (BUFFER_POOL KEEP);

select table_name,cache,blocks from user_tables where buffer_pool='KEEP';

select BUFFER_POOL,INDEX_NAME from user_indexes where INDEX_NAME='IDXTEST75004_AB5'
union
select BUFFER_POOL ,INDEX_NAME from user_indexes where INDEX_NAME='IDXTEST75004_AB7';

drop index IDXTEST75004_AB5

alter index IDXTEST75004_IDAB4 storage (buffer_pool keep) nocache;

alter index tbcs0522.IDXTEST75004_IDAB4 storage nocache;

drop index IDXTEST75004_IDAB4
alter table cust_u_lxh.TP_SYS_TASK nocache;

--对于普通LOB类型的segment的cache方法

alter table t2 modify lob(c2) (storage (buffer_pool keep) cache);
--取消缓存
alter table test modify lob(address) (storage (buffer_pool keep) nocache);

create index idxtest75004_ab4_mod200 on test75004(mod(ab4,200));
analyze table test75004 compute statistics;

select mod(ab4,200) from test75004

analyze table idxtest75004_ab7 compute statistics;

ALTER SYSTEM FLUSH SHARED_POOL

create index idxtest75004_ab7 on test75004(ab7);
create index idxtest75004_ab5 on test75004(ab5);

analyze table test75004 compute statistics;

analyze table test75004 compute statistics for all indexes;
drop index idxtest75004_ab5

SELECT C.sample_time 执行时间,
A.ELAPSED_TIME_DELTA / 1000 "执行耗时(ms)",
B.sql_text SQL文本,
to_char(SUBSTR(B.sql_text, 1, 400)) SQL文本截取
FROM dba_hist_sqlstat A
LEFT JOIN dba_hist_sqltext B
ON A.sql_id = B.sql_id
LEFT JOIN dba_hist_active_sess_history C
ON C.sql_id = B.sql_id
WHERE PARSING_SCHEMA_NAME = 'TBCS0522'
AND C.sample_time IS NOT NULL

ORDER BY C.sample_time DESC;

drop index IDXTEST75004_AB6

SELECT A.sql_ID, to_char(B.begin_interval_time,'yyyy-MM-dd HH24:mi:ss') 执行时间
A.elapsed_time_delta "执行耗时(us)",
T3.sql_text SQL文本,
to_char(SUBSTR(T3.sql_text,1,400)) SQL文本截取
FROM dba_hist_sqlstat A
LEFT JOIN DBA_HIST_SNAPSHOT B ON A.snap_id = B.snap_id
LEFT JOIN dba_hist_sqltext T3 ON A.sql_id = T3.sql_id
WHERE PARSING_SCHEMA_NAME= 'TBCS0522'
ORDER BY begin_interval_time DESC;

select first_load_time,last_load_time,last_active_time,sql_text,EXECUTIONS from v$sql where sql_text like '%id,ab2,ab3,ab4,ab5,ab6,ab7,ab8,ab9,ab10,ab11%'
2023/5/24 11:16:57

2023-05-24/11:17:12

select avg(elapsed_time)/1000 平均时间ms,min(elapsed_time)/1000 最短时间ms,max(elapsed_time)/1000 最大时间ms from (
select first_load_time,last_load_time,last_active_time,sql_fulltext,elapsed_time,sql_text,EXECUTIONS from v$sql
where sql_text like '%600w%' and sql_text not like '%explain%' --and last_active_time> sysdate-1/24
and sql_text not like '%to_char%' and sql_text not like '%sql_fulltext%' and sql_text not like '%v$sql%'
--and first_load_time > to_date('2023-05-24 11:16:57','yyyy-MM-dd HH24:mi:ss')
order by last_load_time desc ) where rownum < 1000

select * from (
select first_load_time,last_load_time,last_active_time,sql_fulltext,elapsed_time,sql_text,EXECUTIONS from v$sql
where sql_text like '%600w%' and sql_text not like '%explain%' -- and last_active_time> sysdate-1/24
and sql_text not like '%to_char%' and sql_text not like '%sql_fulltext%' and sql_text not like '%v$sql%'
--and first_load_time > to_date('2023-05-24 11:16:57','yyyy-MM-dd HH24:mi:ss')
order by last_load_time desc ) where rownum < 1000

select * from (
select first_load_time,last_load_time,last_active_time,sql_fulltext,elapsed_time,sql_text,EXECUTIONS from v$sql
where sql_text like '%7400w%' and executions =1
order by last_load_time desc ) where rownum < 10000

SELECT c.username, a.program, b.sql_text, b.command_type, a.sample_time
FROM dba_hist_active_sess_history a JOIN dba_hist_sqltext b ON a.sql_id = b.sql_id JOIN dba_users c ON a.user_id = c.user_id WHERE a.sample_time BETWEEN SYSDATE - 3 AND SYSDATE AND b.command_type IN (7, 85) ORDER BY a.sample_time DESC;

show parameter shared_pool_size

select count(*) from v$sql

select min(LAST_ACTIVE_TIME) from v$sql

select first_load_time,last_load_time,last_active_time,sql_fulltext,elapsed_time,sql_text,EXECUTIONS from v$sql
order by last_load_time desc

select PLSQL_EXEC_TIME from v$sqlarea

select * from v$his

create
select 263850196/1024/1024 from dual

select to_date('2023-05-24 11:16:57','yyyy-MM-dd HH24:mi:ss') from dual

select sql_fulltext,elapsed_time,last_active_time from v$sql where sql_text like '%id,ab2,ab3,ab4,ab5,ab6,ab7,ab8,ab9,ab10,ab11%'

create index idxtest75004_ab4_mod200 on test75004(mod(ab4,200));
analyze table test7400w compute statistics;

update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 0;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 1;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 2;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 3;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 4;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 5;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 6;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 7;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 8;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 9;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 10;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 11;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 12;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 13;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 14;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 15;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 16;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 17;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 18;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 19;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 20;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 21;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 22;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 23;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 24;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 25;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 26;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 27;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 28;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 29;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 30;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 31;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 32;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 33;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 34;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 35;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 36;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 37;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 38;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 39;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 40;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 41;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 42;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 43;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 44;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 45;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 46;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 47;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 48;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 49;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 50;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 51;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 52;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 53;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 54;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 55;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 56;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 57;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 58;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 59;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 60;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 61;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 62;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 63;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 64;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 65;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 66;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 67;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 68;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 69;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 70;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 71;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 72;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 73;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 74;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 75;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 76;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 77;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 78;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 79;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 80;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 81;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 82;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 83;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 84;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 85;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 86;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 87;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 88;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 89;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 90;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 91;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 92;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 93;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 94;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 95;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 96;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 97;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 98;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 99;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 100;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 101;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 102;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 103;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 104;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 105;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 106;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 107;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 108;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 109;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 110;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 111;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 112;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 113;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 114;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 115;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 116;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 117;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 118;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 119;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 120;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 121;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 122;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 123;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 124;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 125;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 126;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 127;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 128;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 129;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 130;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 131;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 132;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 133;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 134;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 135;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 136;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 137;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 138;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 139;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 140;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 141;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 142;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 143;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 144;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 145;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 146;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 147;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 148;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 149;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 150;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 151;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 152;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 153;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 154;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 155;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 156;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 157;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 158;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 159;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 160;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 161;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 162;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 163;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 164;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 165;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 166;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 167;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 168;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 169;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 170;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 171;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 172;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 173;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 174;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 175;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 176;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 177;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 178;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 179;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 180;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 181;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 182;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 183;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 184;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 185;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 186;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 187;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 188;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 189;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 190;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 191;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 192;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 193;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 194;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 195;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 196;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 197;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 198;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 199;
commit;
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)= 200;
commit;

update test75004 set ab6=dbms_random.string('a',5) where mod(ab4,200)=1 ;

select dbms_random.string('a',5) from dual

select 2000000000/(52*52*52*52*52) from dual
update /*+append*/ test75004 set ab6=dbms_random.string('a',5) where ab4=6565541;
commit;

select * from test75004 where ab4=6565541

update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 0;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 1;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 2;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 3;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 4;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 5;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 6;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 7;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 8;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 9;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 10;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 11;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 12;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 13;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 14;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 15;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 16;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 17;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 18;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 19;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 20;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 21;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 22;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 23;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 24;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 25;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 26;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 27;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 28;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 29;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 30;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 31;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 32;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 33;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 34;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 35;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 36;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 37;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 38;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 39;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 40;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 41;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 42;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 43;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 44;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 45;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 46;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 47;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 48;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 49;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 50;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 51;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 52;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 53;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 54;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 55;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 56;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 57;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 58;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 59;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 60;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 61;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 62;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 63;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 64;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 65;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 66;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 67;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 68;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 69;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 70;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 71;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 72;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 73;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 74;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 75;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 76;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 77;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 78;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 79;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 80;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 81;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 82;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 83;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 84;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 85;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 86;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 87;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 88;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 89;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 90;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 91;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 92;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 93;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 94;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 95;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 96;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 97;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 98;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 99;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 100;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 101;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 102;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 103;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 104;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 105;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 106;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 107;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 108;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 109;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 110;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 111;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 112;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 113;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 114;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 115;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 116;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 117;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 118;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 119;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 120;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 121;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 122;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 123;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 124;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 125;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 126;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 127;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 128;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 129;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 130;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 131;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 132;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 133;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 134;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 135;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 136;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 137;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 138;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 139;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 140;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 141;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 142;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 143;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 144;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 145;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 146;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 147;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 148;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 149;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 150;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 151;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 152;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 153;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 154;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 155;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 156;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 157;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 158;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 159;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 160;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 161;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 162;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 163;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 164;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 165;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 166;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 167;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 168;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 169;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 170;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 171;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 172;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 173;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 174;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 175;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 176;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 177;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 178;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 179;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 180;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 181;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 182;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 183;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 184;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 185;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 186;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 187;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 188;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 189;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 190;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 191;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 192;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 193;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 194;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 195;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 196;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 197;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 198;
commit;
update /*+append*/ test75004 set ab7=substr(ab6,1,4) where mod(ab4,200)= 199;
commit;

select ab1,ab2,ab3,ab4,ab5,ab6,ab7,ab8,ab9,ab10,ab11,ab12,ab13,ab14,ab15,ab16,ab17,ab18, ab19,ab20,ab21,ab22,ab23,ab24,ab25,ab26,ab27,ab28,ab29,ab30,ab31,ab32,ab33,ab34,ab35 from test7400w where ab1= 641661978 and ab2 = 7231767 and ab3 = 23072552 and ab4 = 492200 and ab5 = 'djHY' and ab6 = 'tYgC' and ab7 = 'REzy' and ab8 = 'iFbZuDlKqGyVILXCZVEvLLSEYhETBEEr' and ab9 = 'h' and ab10 = 236593 and ab11 = 'BTvKzjFOElufbSukxcPSDHnftwHpCYXA' and ab12 = 584392 and ab13 = 518552 and ab14 = 3079233 and ab15 = 'WlekI' and ab16 = 4720349 and ab17 = to_date('2023-05-28 09:00:56','yyyy-MM-dd HH24:mi:ss') and ab18 = to_date('2023-05-07 09:26:55','yyyy-MM-dd HH24:mi:ss') and ab19 = 'uXTR' and ab20 = 282848 and ab21 = 'wR' and ab22 = to_date('2022-12-23 05:43:36','yyyy-MM-dd HH24:mi:ss') and ab23
drop index IDX_74W_Ab3;
drop index IDX_74W_AB6;
drop index IDX_74W_AB8;

create index idx_ab2_test75004 on test75004(ab2);

create table test750041 as select * from ( select t.*,rownum rm
from test75004 t
where ab2 is not null and
ab3 is not null and
ab4 is not null and
ab5 is not null and
id is not null and
rownum<10050) where rm >50;

select * from test750041
MINUS
select t.*,rownum rm
from test75004 t
where ab2 is not null and
ab3 is not null and
ab4 is not null and
ab5 is not null and
id is not null and
rownum<10000;

2700000 65s

100000 1.338 36s

10000 0.314 3140s

select 10000*0.314,1.338*27 ,20.292*2.7,0.771*270/5，270*2.956/15,270*0.314 from dual

update test75004 t set ab4=ab4+1
where ab2 is not null and
ab3 is not null and
ab4 is not null and
ab5 is not null and
id is not null and
rownum<26040;
commit;
select count(*) from test75008

select * from test75008

select Utl_Raw.Cast_To_Raw(sys.dbms_obfuscation_toolkit.md5(input_string => id||ab2||ab3||ab4||ab5||ab6||ab7||ab8||ab9||ab10||ab11||ab12||ab13||ab14||ab15||ab16||ab17||ab18||ab19||ab20||ab21||ab22||ab23||ab24||ab25||ab26||ab27||ab28||ab29||ab30||ab31||ab32||ab33||ab34||ab35)) from test75004
where rownum<26040;

create index idx_md5_test75004 on test75004(
sys.dbms_obfuscation_toolkit.md5(input_string => id||ab2||ab3||ab4||ab5||ab6||ab7||ab8||ab9||ab10||ab11||ab12||ab13||ab14||ab15||ab16||ab17||ab18||ab19||ab20||ab21||ab22||ab23||ab24||ab25||ab26||ab27||ab28||ab29||ab30||ab31||ab32||ab33||ab34||ab35)
);
select name,last_change# from v$datafile;
select name,checkpoint_change# from v$datafile_header;
select checkpoint_change# from v$database;

drop index IDX_74W_NVLAB8

select Utl_Raw.Cast_To_Raw(sys.dbms_obfuscation_toolkit.md5(input_string => '12345') from test75004
where rownum<26040;

select Utl_Raw.Cast_To_Raw(sys.dbms_obfuscation_toolkit.md5(input_string => '12345')) from dual
827CCB0EEA8A706C4C34A16891F84E7B
827ccb0eea8a706c4c34a16891f84e7b

select * from v$session;

select * from dba_data_files

select count(*) from test7400w where ab8 is null
create index idx_74w_ab1 on test7400w ( MOD(ab1,1000));
create index idx_74w_ab3 on test7400w ( ab3);

update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;
update /*+append*/ test7400w nologging set ab6=null where MOD(ab1,1000)=trunc(dbms_Random.Value(0, 1000));
commit;

drop index IDX_74W_AB1_AB6_AB8

create index idx_test7400w_ab6 on test7400w(ab6);
create index idx_100w_ab6 on test100w(ab6);
create index idx_1000w_ab6 on test1000w(ab6);
create index idx_900w_ab6 on test900w(ab6);
create index idx_800w_ab6 on test800w(ab6);
create index idx_700w_ab6 on test700w(ab6);
create index idx_600w_ab6 on test600w(ab6);
create index idx_500w_ab6 on test500w(ab6);
create index idx_400w_ab6 on test400w(ab6);
create index idx_300w_ab6 on test300w(ab6);

analyze table test800w compute statistics;
analyze table test700w compute statistics;
analyze table test600w compute statistics;
analyze table test500w compute statistics;
analyze table test400w compute statistics;

insert into test800w select * from test1000w where rownum <200;
commit;

select count(*) from test800w

analyze table idx_900w_ab6 compute statistics;
analyze table idx_1000w_ab6 compute statistics;
analyze table test7400w compute statistics;

create table test10w as select * from test7400w where rownum<100000
create table test100w as select * from test7400w where rownum<1000000
drop table test900w
create table test900w as select * from test7400w where rownum<9000000;
create table test800w as select * from test7400w where rownum<8000000;
create table test700w as select * from test7400w where rownum<7000000;
create table test600w as select * from test7400w where rownum<6000000;
create table test500w as select * from test7400w where rownum<5000000;
create table test400w as select * from test7400w where rownum<4000000;
create table test300w as select * from test7400w where rownum<3000000;
create table test200w as select * from test7400w where rownum<2000000;

create table test1000w as select * from test7400w where rownum<10000000

create index idx_74w_ab6 on test7400w(ab6);

IDX_74W_AB8

select min(SCN) min_scn from sys.smon_scn_time;
SECT SCN_TO_TIMESTAMP(78303819) FROM dual;

select min(SCN) min_scn from sys.smon_scn_time;
select dbms_metadata.get_ddl('TABLE','SMON_SCN_TIME','SYS') FROM DUAL ;

select * from smon_scn_to_time_aux;

smon_scn_to_time_aux

create index idx_74w_ab8 on test7400w(ab6);
analyze table test800w compute statistics for all indexes;

select t.* from ( select rownum as rm,ab3, ab6,ab8, 'select ab1,ab2,ab3,ab4,ab5,ab6,ab7,ab8,ab9,ab10,ab11,ab12,ab13,ab14,ab15,ab16,ab17,ab18,
ab19,ab20,ab21,ab22,ab23,ab24,ab25,ab26,ab27,ab28,ab29,ab30,ab31,ab32,ab33,ab34,ab35 from test10w
where ab1= '||ab1||' and
ab2 = '||ab2||' and
ab3 '||NVL2( ab3,'='|| ab3||'', ' is null ') ||' and
ab4 = '||ab4||' and
ab5 = '''||ab5||''' and
ab6 '||NVL2( ab6,'='''|| ab6||'''', ' is null ') ||' and
ab7 = '''||ab7||''' and
ab8 '||NVL2( ab8,'='''|| ab8||'''', ' is null ') ||' and
ab9 = '''||ab9||''' and
ab10 = '||ab10||' and
ab11 = '''||ab11||''' and
ab12 = '||ab12||' and
ab13 = '||ab13||' and
ab14 = '||ab14||' and
ab15 = '''||ab15||''' and
ab16 = '||ab16||' and
ab17 = to_date('''||to_char(ab17,'yyyy-MM-dd HH24:mi:ss')||''',''yyyy-MM-dd HH24:mi:ss'') and
ab18 = to_date('''||to_char(ab18,'yyyy-MM-dd HH24:mi:ss')||''',''yyyy-MM-dd HH24:mi:ss'') and
ab19 = '''||ab19||''' and
ab20 = '||ab20||' and
ab21 = '''||ab21||''' and
ab22 = to_date('''||to_char(ab22,'yyyy-MM-dd HH24:mi:ss')||''',''yyyy-MM-dd HH24:mi:ss'') and
ab23 = ''testtesttesttesttesttest'' and
ab24 = to_date('''||to_char(ab24,'yyyy-MM-dd HH24:mi:ss')||''',''yyyy-MM-dd HH24:mi:ss'') and
ab25 = to_date('''||to_char(ab25,'yyyy-MM-dd HH24:mi:ss')||''',''yyyy-MM-dd HH24:mi:ss'') and
ab26 = ''testtesttesttesttest'' and
ab27 = ''testtesttesttesttest'' and
ab28 = ''testtesttesttesttest'' and
ab29 = ''testtesttesttesttest'' and
ab30 = ''testtesttesttesttest'' and
ab31 = ''testtesttesttesttest'' and
ab32 = ''testtesttesttesttest'' and
ab33 = ''testtesttesttesttest'' and
ab34 = ''testtesttesttesttest'' and
ab35 = ''testtesttesttesttest''
;'
from test10w
where
rownum<2000 ) t where rm >1000

标签

#dba #数据库