Re: database network performance requirements

From: joel garry <>
Date: Thu, 4 Feb 2010 09:07:41 -0800 (PST)
Message-ID: <>

On Feb 3, 2:28 pm, vsevolod afanassiev <> wrote:
> Requirements vary from application to application. Well-written
> application cache static data.
> There are several network-related statistics, this is from Statspack
> report for database:
> Statistic                                      Total     per Second
> per Trans
> --------------------------------- ------------------ --------------
> ------------
> SQL*Net roundtrips to/from client         15,714,040
> 436.5         22.2
> bytes received via SQL*Net from c      5,056,985,913
> 140,475.7      7,144.4
> bytes sent via SQL*Net to client       3,173,523,378
> 88,155.9      4,483.5

A single application is the wrong level to determine this. The dba presumably is responsible for allocuting all Oracle related network usage. So, at a minimum, it would need to be statistics as above for all applications current and contemplated, projected forward, plus the likelihood of disaster or distributed usage. The latter means archiving transport, and rman usage over the net (among other possibilities). For example, to build a standby database you have to figure how much data there is uncompressed (in case there happens to be some bug that disallows the compression option), and how fast you will need to rebuild such a beast from scratch should the archive gap become untenable. If management's view is "no, we will never lose our computer room due to the upstairs crapper overflowing," get an experienced consultant in there.

Another way to get around penny-pinching network resources is to get a video conferencing project, that means big pipes for everyone.


-- is bogus.
That darn internet!
Received on Thu Feb 04 2010 - 11:07:41 CST

Original text of this message