监控用的procedure
CREATE OR REPLACE PROCEDURE DBINFO.sp_write_dfh_log_bakupdate
as
v_dblnkname01 dbinfo.db_info_test.dblnk_name01%type ;
v_dbn number := 0 ;
v_sql varchar2(4000) := '' ;
cursor c_dbtest is
select upper(dblnk_name01)
from dbinfo.db_info_test
;
begin
execute immediate 'truncate table dbinfo.dfh_log' ;
open c_dbtest ;
loop
--for v_dbn in c_testdb loop
--begin
fetch c_dbtest into v_dblnkname01 ;
exit when c_dbtest%notfound;
v_sql := 'insert into /*+append*/ dbinfo.dfh_log(hostname,TBS_NAME ,SIZE_ALLOC_MAX ,SIZE_USED ,SIZE_USED_PERCENT) select '
||' host_name,' ||'TBS_NAME ,'
||' SIZE_ALLOC_MAX,'
||'SIZE_USED, '
||'SIZE_USED_PERCENT '
||'from '
||'dbamonitor.dfh_log@'
||v_dblnkname01
||',v$instance@'
||v_dblnkname01
;
commit;
execute immediate (v_sql) ;
commit ;
end loop
;
close c_dbtest ;
end;
/
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/23757700/viewspace-700133/ ，如需转载，请注明出处，否则将追究法律责任。
