how to determine network traffic size
alpDec 8 2009 — edited Dec 9 2009Hello, I have an interesting problem.
I'd like to determine, how many bytes will be send by server to response of a query. Query is undefined. We know only fields in result set, but they are changing from query to query.
Let's say, we have a query
SELECT a,b,c FROM table;
We can note, that
SELECT sum(nvl(vsize(a),0) nvl(vsize(b),0) nvl(vsize(c),0)) from table
is different (for small tables it is less in several times) from actual network traffic size.
(e.g, for about 500 bytes of data we have about 2000 bytes of network traffic (got by tcpdump)).
But can we estimate the network traffic size for a query?