#目标用户
sqlplus / as sysdba
create user test identified by test default tablespace apps;
grant connect,resource,select any dictionary to test;
#模拟正在运行的SQL
select sid from v$mystat where rownum=1;
declare
n int;
begin
for i in 1..1000 loop
execute immediate 'select count(0) from dba_objects where object_type in(''TABLE'',''VIEW'') and object_name like ''%CON%''' into n;
end loop;
end;
select sid from v$mystat where rownum=1;
declare
n int;
begin
for i in 1..1000000 loop
execute immediate 'select owner,object_type,object_name from dba_objects where owner=''SYS'' and object_type in(''TABLE'',''VIEW'') and object_name like ''%CON%'' order by owner,object_type,object_name' ;
end loop;
end;
select a.tablespace_name,
round(sum(a.bytes)/1024/1024,2) as "TOTAL_SIZE(MB)",
round(sum(b.bytes)/1024/1024,2) as "FREE_SIZE(MB)",
round(1-sum(b.bytes)/sum(a.bytes),4)*100||'%' as "USAGE_RATE",
case when 1-round(sum(b.bytes)/sum(a.bytes),4)>dp_mon_build.get_mon_threshold('TABLESPACE_USAGE_RATE') then 1 else 0 end as "IF_WARN"
from dba_data_files a,dba_free_space b
where a.TABLESPACE_NAME=b.TABLESPACE_NAME
group by a.tablespace_name
truncate table mon_log;
truncate table mon_log_detail;
select * from MON_THRESHOLD for update
select * from mon_script for update
select * from mon_log;
select * from mon_log_detail;
truncate table secure;
insert into secure select * from dba_objects;
insert into secure select * from secure;
insert into secure select * from secure;
insert into secure select * from secure;
insert into secure select * from secure;
commit;
select count(0) from syn_log where if_syn='N' and tname='LX2' order by syn_id;
update syn_log set if_syn='N' where tname='LX2';
select sum(decode(otype,'I',1,0)) as ins_rec,
sum(decode(otype,'U',1,0)) as upd_rec,
sum(decode(otype,'D',1,0)) as del_rec,
sum(decode(otype,'DDL',1,0)) as ddl_rec
from SYN_LOG where if_syn='N' and tname='LX2'
select count(0) from syn_log
where if_syn='N'
and tname='LX2'
and ddl_stat like '%CREATE%' and ddl_stat like '%TABLE%'
select * from syn_log where if_syn='N' and tname='LX2' order by syn_id;
and syn_id between 154 and 1000
alter session set db_file_multiblock_read_count=256;
select dp_syn_build.gen_syn_sql(syn_id) as exec_sql,syn_id,if_syn,
decode(otype,'D','DML','I','DML','U','DML',otype) as otype
from SYN_LOG
where if_syn='N' and tname='LX2'
order by syn_id
oclient.rar （14个子文件） 
oclient sql table 
external_table.txt 1KB
cre_mon_tab.sql 2KB package dp_mon_build.pck 18KB dp_syn_build.pck 132KB dp_ops_build.pck 12KB test beauty.txt 6KB test.sql 4KB script ins_mon_script.sql 997B trigger cre_tri.sql 193B grant grant.sql 144B readme.txt 3KB doc 
Oracle运维工具oclient V3.0 使用手册.docx 252KB config.ini 2KB oclient.py 65KB资源评论
