Re: Oracle 8i Network bandwidth problem?

Your problem may be dependent on the nature and style of your client processing. The big difference between (say) file transfer and Oracle client/server dialogue is that the dialog is done in relatively small chunks, and synchronously, whereas the file transfer can be streamed asynchronously with a 'request for a missed packet' sent when necessary.

Often the biggest issue is that the client application is written to process data one row at a time - resulting in maximum cost on turning around lots of very small packets. The first thing I would check is whether the clients are using array processes, and what figures 'netstat' is giving you for round-trips per second.

--
Jonathan Lewis
http://www.jlcomp.demon.co.uk

Host to The Co-Operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Author of:
Practical Oracle 8i: Building Efficient Databases

Screen saver or Life saver: http://www.ud.com
Use spare CPU to assist in cancer research.

Oliver Schubert wrote in message <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

>

>