Message-Id: <10536.110182@fatcity.com> From: Oliver Artelt Date: Thu, 22 Jun 2000 20:48:12 +0200 Subject: Re: SQL*Net overhead On Thu, 22 Jun 2000, Steve.Parker@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 ? > v$sysstat is your friend if you have a database on which you are alone. Read the values around #168, do the query and read again. oli. Oliver Artelt, System- und Datenbankadministration --------------------------------------------------------------- cubeoffice GmbH & Co.KG # jordanstrasse 7 # 39112 magdeburg telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 10 email: oli@cubeoffice.de # web: http://www.cubeoffice.de ---------------------------------------------------------------