Re: database network performance requirements

From: vsevolod afanassiev <vsevolod.afanassiev_at_gmail.com>
Date: Wed, 3 Feb 2010 14:28:57 -0800 (PST)
Message-ID: <694e922b-0ae8-4d4c-88e1-13c207c7deb5_at_h9g2000prn.googlegroups.com>

Requirements vary from application to application. Well-written application cache static data.
There are several network-related statistics, this is from Statspack report for 9.2.0.8 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

Received on Wed Feb 03 2010 - 16:28:57 CST