Re: SQL*Net overhead

From: Oliver Artelt <oli_at_cubeoffice.de>
Date: Thu, 22 Jun 2000 20:48:12 +0200
Message-Id: <10536.110182@fatcity.com>

On Thu, 22 Jun 2000, 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 ?
>

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

---

Received on Thu Jun 22 2000 - 13:48:12 CDT