디비링크 사용량 모니터링

디비링크 네트워크 사용량 모니터링

수신된 바이트 수

-- total number of bytes received
select s.value 
  from v$sysstat s
     , v$statname n 
 where n.name='bytes received via SQL*Net from dblink' 
   and n.statistic#=s.statistic#;

송신한 바이트 수

-- total number of bytes sent
select s.value 
  from v$sysstat s
     , v$statname n 
 where n.name='bytes sent via SQL*Net to dblink' 
   and n.statistic#=s.statistic#;

송/수신 정보

--SQL*Net bytes sent for a session.
select *
  from gv$sesstat
  join v$statname
    on gv$sesstat.statistic# = v$statname.statistic#
-- You probably also want to filter for a specific INST_ID and SID here.
 where lower(display_name) like '%sql*net%';

--SQL*Net bytes sent for the entire system.
select *
  from gv$sysstat
 where lower(name) like '%sql*net%'
 order by value desc;