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

Home -> Community -> Usenet -> c.d.o.server -> Oracle 8i Network bandwidth problem?

Oracle 8i Network bandwidth problem?

From: Oliver Schubert <OSchubert_at_timocom.de>
Date: 25 Sep 2001 02:22:03 -0500
Message-ID: <3bb02ff4$0$1146$45beb828@newscene.com>


Hi oracle sirs ;-)

my oracle database must serve a lot of data for big sql querys to replicate datas with the users. The answer time is very good, but oracle only uses 3 mBytes/second bandwidth from our 13 mBytes/second (100 MBit/Ethernet) network. When i copy files (e.g. my orabackup.ora file with 700MB), the bandwidth using grows up to 9 mBytes/second and more.

Now my question: how fast can serve Oracle data via network. The miss rates are very low (nearly 0,02 percent), the physical I/O are lower then 10 IO/sec. Oracle uses 490 MB from the 1 GB memory and the CPU use are about 30 percent (with two 850 MHZ CPU). All my tools (EZSQL, TOAD) says that everything is allright, but whats about the network using?

All information i can reach is about normal database use, but in my case i must replicate a lot of users (up to 6000 a day) a lot of time (up to 25.000 logins a day), witch means, that they want to update 10 tables with nearly 100.000 rows.

Please help me,
very best regards,
Oliver Schubert Received on Tue Sep 25 2001 - 02:22:03 CDT

Original text of this message

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