gathering network requirements for a database.

From: Joel Slowik <jslowik_at_cps92.com>
Date: Fri, 24 Apr 2015 18:51:04 +0000
Message-ID: <DM2PR07MB448700C0FA94B659BD134FBB1EC0_at_DM2PR07MB448.namprd07.prod.outlook.com>



Happy Friday list,

This should be an easy one for all of you. I need to measure how much data is passed to and from the database via the network (not loading/unloading database data to files on the server). Having one of our apps sending data from a file to the database is easy to calculate, but I also need to capture the size of transactions being sent through the wire. I have in my STATSPACK reports 'bytes sent via sql*net to client' and 'bytes received via sql*net from client', and that seems to be providing me with at least one indicator how expected network load.

What other datapoints (in statspack, database, or otherwise) can assist me in getting the data that I am looking for?

We are currently using 11.2.0.4 for most of our databases.

Thanks,
-joel slowik



 Confidentiality Note: This electronic message transmission is intended only for the person or entity to which it is addressed and may contain information that is privileged, confidential or otherwise protected from disclosure. If you have received this transmission, but are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of the contents of this information is strictly prohibited. If you have received this e-mail in error, please contact Continuum Performance Systems at {203.245.5000} and delete and destroy the original message and all copies.
--

http://www.freelists.org/webpage/oracle-l Received on Fri Apr 24 2015 - 20:51:04 CEST

Original text of this message