Network Traffic Volume

[helsinki]

In Oracle 10g, there is a table called dba_hist_sysmetric_summary which stores lot of useful information about the database activities. One of the metric is called NETWORK TRAFFIC VOLUME per sec(metric_id=2058). In my case, for a particular time period, the maximum value stored for this particular metric was 2.2GB bytes per sec. But our network hardware doesn't support this much transaction. The above value is a very large number in our case. Our network resource does not support this much transaction rate. Could some one throw light on what does ORACLE mean by the metric NETWORK TRAFFIC VOLUME PER SEC?

[akas_chauhan]

SOunds wired then.
Execute this and post the result.

select maxval/(1024*1024*1024) from dba_hist_sysmetric_summary where upper(metric_name) like '%VOL%' order by maxval desc

[helsinki]

Thank you for responding to my post.

following are the top five values for your query.

2.28443097801845
1.86200318944748
1.82911570979712
1.79601107666094
1.65568664294183

[akas_chauhan]

Looks pretty wired though. BTW what's your n/w bandwidth from your D/B server?

[helsinki]

Hi Akash,

Thanks for the response.

My sysadmin says even at peak load, traffic is only around 800 kilo bits per second between DB and application server. Also he said we are having a 1GB network card.

I feel oracle calculation is wrong for this NETWORK TRAFFIC VOLUME metric. If you have access to metalink could you please check in oracle site.

Thanks,
Danny.