[작업능률향상방안#2][DBMS_SYSTEM.KSDWRT 프로시저를 이용한 모니터링 방법]
작업효율향상방안 2008/11/19 12:15아래의 프로시져는 3개의 주요 성능 지표에 대한 초단위 Delta 결과를 트레이스 파일에 출력하는 예제이다.
declare
TYPE SysStatType IS TABLE OF v$sysstat%ROWTYPE
INDEX BY PLS_INTEGER;
sys_stat_res1 SysStatType;
sys_stat_res2 SysStatType;
begin
for i in 1..10000 loop
for i in 1..3 loop
select statistic#, name, class, value, stat_id
into sys_stat_res1 (i)
from (select rownum rnum, statistic#, name, class, value, stat_id
from v$sysstat
where name in ('session logical reads',
'physical reads',
'physical writes'))
where rnum=i;
end loop;
dbms_lock.sleep(1);
for i in 1..3 loop
select statistic#, name, class, value, stat_id
into sys_stat_res2 (i)
from (select rownum rnum, statistic#, name, class, value, stat_id
from v$sysstat
where name in ('session logical reads',
'physical reads',
'physical writes'))
where rnum=i;
end loop;
for i in 1..3 loop
dbms_system.ksdwrt(1, to_char(sysdate,'YYYYMMDD:HH24:MI:SS')||' '||sys_stat_res2(i).name||'=>'||(sys_stat_res2(i).value-sys_stat_res1(i).value));
end loop;
end loop;
end;
/
