Measuring traffic from a host to the Oracle Server 1

[Shaad]

Hello, I have a Linux machine connecting to an Oracle database frequently. I'm trying to determine how much traffic on average is transferred between the Webserver and the Database. Does anyone have any suggestions on how I might accomplish this?

Both hosts are on the same network connected via a Catalyst 4006 Switch.

Thanks in advance!

Nick

 

[DBAwhosaysNIE]

a reading from the book of v$:

select vsn.machine,
sum(decode(vst.statistic#,182,vst.value,0)) as sent_bytes,
sum(decode(vst.statistic#,183,vst.value,0)) as received_bytes,
sum(vst.value) as total_bytes
from v$session vsn,
v$sesstat vst
where vsn.sid=vst.sid
and vsn.machine='<some_machine>'
and vst.statistic# in (182,183)
group by vsn.machine
/

this is the word of Larry...