Re: Oracle 8i Network bandwidth problem?

Just my 2 cents...

Oracle is I/O and CPU intensive, it does not demand much of network bandwidth. The returned cursors from large queries are large packets and are pretty efficient. You gain more by tweeking the process than by adding network bandwidth, usually...

Most certainly your bottleneck will be disk access. You might want to spread those tables over multiple disks and separate indexes too. Load balancing your I/O will yeald the greatest returns...

Then others might have a different opinion..

Regards,

Serge

"Oliver Schubert" <OSchubert_at_timocom.de> wrote in message news:3bb02ff4$0$1146$45beb828_at_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 - 12:52:16 CDT