Skip to Main Content
  • Questions

  • how to get network traffic to a database.

Breadcrumb

Question and Answer

Connor McDonald

Thanks for the question, ezio.

Asked: October 15, 2015 - 5:57 am UTC

Last updated: October 15, 2015 - 12:03 pm UTC

Version: 9i

Viewed 1000+ times

You Asked

Hi:
Here we have a requirement ，My factory want to add a production line at the other city,but the database is still here.
So i want to know the network traffic to this database per day (especially the max traffic).
Is there any idea or view to help me find out?
or another way to do this thing.

If not can I use transaction count instead ?(How to)
Thanks .

and Connor said...

You could measure from v$sesstat and v#sysstat, the statistic "bytes sent via SQL*Net to client" at regular intervals. That will the database's impression of what data it sent down to clients. There is also "bytes received via SQL*Net from client" which is incoming data.

At a lower level, you could use a (free) tool like Wireshark which will actually sniff the network interface for packets coming out of the database server.

Hope this helps.

Rating

  (3 ratings)

Is this answer out of date? If it is, please let us know via a Comment

Comments

Something more want to know

ezio, October 15, 2015 - 7:39 am UTC

Thanks a lot , that maybe helpful, then I want to know if the value of the 'bytes received via SQL*Net from client' will set to 0 if the instance restart.
Connor McDonald
October 15, 2015 - 12:03 pm UTC

Yes it will.

So if you are regularly bouncing your instance (which in itself is not a good idea), then you would need to take a copy of the relevant stats on shutdown.


THANKS

ezio, October 16, 2015 - 5:08 am UTC

THANKS

Network latency

Jon Stone, October 19, 2015 - 12:19 pm UTC

You may also want to monitor "SQL*Net roundtrips to/from client" too. If the application is very "chatty" OLTP-style application which performs lots of round trips to the database then you may find that network latency has a significant impact on application performance.
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's channel and Chris's channel from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.