Improving performance

Abstract

We are actually facing performance problems with our network links between remote sites client and their servers. Those clients are connected to a server using 19200Kbps links using Ethernet protocols.

The kind of configuration and applications described here is found on many sites. The objective of this document is to build a list of tools, tips and tricks for those of us who face that kind of problem.

Configuration facts

• Hardware : Sun servers and workstations
• Operating System : SunOS V4.2 (soon to be upgraded to Solaris 2.2)
• GUI : X11R5 and OpenWindows
• Data Base : Oracle V6.0.33 (soon to be ugraded to V7)
• Other products : ESRI Arc/Info Geographical Information System HOOPS libraries for C
• Applications :
  • In house developed Oracle SQL*Forms and Pro*C applications
  • In house developed application to draw X-Y graphs using HOOPS of data comming from Oracle
  • In house developed GIS application to draw Oracle data over maps

Other considerations

1. Binaries, programs and GIS maps can be located on each client, but sensible data must be kept on the server (mainly Oracle and Arc/Info data).
2. Network links are slow and can't be easily (or at low cost) upgraded to faster speed.

Objectives

1. Is there a way to increase performance of Oracle SQL*Net? Can we expect any improvement with V7?
2. Any solution to use the X protocol (when required) at it's best over such a described configuration?
3. Any tips and tricks to tune SunOS (and Solaris)?
4. Any suggestion to automatically detect and update files changed on a remote system (I think rdist could be usefull here...)
5. And finally, wich tools (public domain or not) could be use to tune and evaluate performance of:
6. Oracle applications and the rdbms itself
7. C programs
8. SunOS and Solaris networking
9. Ethernet and network activity between hubs

I'll post a summary!

Cross posted to:

	comp.databases.oracle
	alt.sys.sun
	comp.sys.sun.admin
	info.sun-managers

--
---
 Stephane Hamel, Sysadmin *.Mais.Hydro.Qc.Ca
 Hydro-Quebec TDSB, Montreal, Quebec
 E-mail: shamel_at_Mais.Hydro.Qc.Ca  Voice: (514) 858-7882  Fax: (514) 858-7799