Re: Oracle 8i Network bandwidth problem?

• Original Message ----- From: Serge <phisolophe_at_hotmail.com> Newsgroups: comp.databases.oracle.server Sent: Tuesday, September 25, 2001 7:52 PM Subject: 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.

That's best case server side only! Oliver provided (almost) no information about
client access method, so it's all guess work. If access is via ODBC-calls, Your
(supposed) efficient server side access is going to be split into little chunks with
awful overhead. But I' sure I missed the point in Oliver's posting because I see
him stating that answer times are good, so what?

> You gain more by tweeking the process than by adding
> network bandwidth, usually...

... especially when measurements say that existing bandwidth is by far not exhausted - couldn't read if Oliver was talking about peak rates, just a guess.

> 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...

Well for me disk access would be one of the last places to look at when it comes to
client/server performance problems, Put some more GB main memory into the machine and have it used (mainly) for caching. If problem disappeares You once
have had a disk access problem -oversimplified, I know ;-) You may want to check SQL statement behaviour frist. ;-))

> Then others might have a different opinion..

Might be the case. ;-)

> Regards,
>
> Serge

... just another 2 cents.

Regards
Rolf

> "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 Thu Sep 27 2001 - 08:11:00 CDT