Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: SQL*Net overhead

Re: SQL*Net overhead

From: Suzy Vordos <lvordos_at_uswest.com>
Date: Thu, 22 Jun 2000 09:01:12 -0600
Message-Id: <10536.110160@fatcity.com>


Nope, but think you can tune it using TDU/SDU in listener.ora and tnsnames.ora. The max value (last time I looked) was 32768.

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).
Received on Thu Jun 22 2000 - 10:01:12 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US