| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: SQL*Net overhead
This is a multi-part message in MIME format.
--------------E9B8BB2F71EB83E6A1512D6C Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit
Exactly the right size :-).
Seriously, estimating future network throughput is a black art best left to network engineers, but the SQL*Net overhead should be quite small compared to the 345000 bytes of payload. It's probably more comparable to the TCP overhead, IP overhead or physical layer overhead. The only way to find out for sure is to install a snoop module between the two-task common layer and the TCP layer to see what's added to the conversation, as it depends on the version, your configuration options, your naming (routing) method, your physical layer (if you include TNS overhead) and whether your connection is encrypted.
Steve.Parker_at_lis.co.uk wrote:
> Has anyone performed any calculations on the
> overhead that SQL*Net imposes on top of the data
> that is passed between a client and server.
>
> e.g. if the client requests 1000 rows where each row is 345 bytes
> in size, what is the overall size of the data passed over the
> network, assuming TCP/IP ?
>
> Thanks in advance
>
> Steve Parker
> Technical Consultant
> LIS
>
> Logistics & Internet Systems Ltd.
> Knaves House, Knaves Beech Business Centre
> Loudwater, High Wycombe
> Buckinghamshire , HP10 9QR, United Kingdom
> Telephone: +44 (0) 1628 859800
> Facsimile: +44 (0) 1628 532688
> E Mail: steve.parker_at_lis.co.uk
>
> --
> Author:
> INET: Steve.Parker_at_lis.co.uk
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
--------------E9B8BB2F71EB83E6A1512D6C
Content-Type: text/x-vcard; charset=us-ascii;
name="djerman.vcf"
Content-Transfer-Encoding: 7bit Content-Description: Card for Don Jerman Content-Disposition: attachment;
begin:vcard
n:Jerman;Don
tel;work:919.250.4177 x282
x-mozilla-html:TRUE
org:Engineering Applications Dev. Unit,Engineering Technology Systems,Preconstruction,Division of Highways
version:2.1
email;internet:djerman_at_dot.state.nc.us
title:Database Administrator
adr;quoted-printable:;;Engineering Applications Dev. Unit,Engineering Technology Systems,Preconstruction,Division of Highways=0D=0A1020 Birch Ridge Drive;Raleigh;NC;27610;USA
x-mozilla-cpt:;-9536
Received on Thu Jun 22 2000 - 15:37:12 CDT
 |
 |