Re: Need help understanding network problems

Dave - I only offer some avenues to explore

Find what you can on sql*net tuning (The O'Reilly book and Oracle Press Book have some info). Essentially you want to use the largest packet size possible to minimize the number of trips across the WAN.

Are you in a position to rework the application? If so, can you cache any data with the client? For example, lookup values.

Get a really good network guru and put a sniffer on the WAN to verify the frame relay is functionally well. Don't assume because MCI says all is well, that it is ok. You didn't say what CIR you have, but if you have a zero CIR and the frame is busy, you may not be getting what you expect.

Is there anything else going across the WAN that is sucking bandwidth?

Any statistics you pull from your routers that will give a clue?

Run the application in the local LAN from a host other than the database server to help get a baseline. I'm running an Oracle 7.3.4 database in NT 4.0 SP3 across 128K frame relay and have responses time around 2 - 3 seconds. Ping times average around 20 ms although my distances are much shorter.

Finally, you need to manage your manager's and user's expectations regarding how long it's going to take to fully solve. Problems like this can be nightmares to solve.

<proteusdNOSPAMPLZ_at_hotmail.com> wrote in message news:LSAWOGbAmTKWy7kibDS2EIOt48xW_at_4ax.com...
> Hi All,
>
> We have an Oracle 8 server on NT 4 sp 5. We are attaching locally to
> it and everything is fine. When we run the app across the WAN to a
> site across the country the application is unusable (Lag from Florida
> to Utah is horrible).
>
> Some info:
> We are using VB5(sp3) with OO4O 2.3
> Assume that the SQL calls are as good as they can be (indexed
> correctly, very trim, etc.)
> We are going through MCI who does our backbone.
> We are using Frame Relay.
> A ping from the client has 3 hops, one to it's router, one to our
> router, and finally to the Oracle server.
> A regular ping from the client is 100 ms (approx.)
> A TNSPing from the client is 240 ms (approx.)
> We are using Net8 with TCPIP.
> In our TNSNAMES.ORA file we specify IP, not the oracle name
> All logging on the server has been turned off (Per Oracle support)
> Our guaranteed throughput is 16K with a max burst of 512K
> MCI says that we are using little (if any) of our speed (basically,
> they are saying it's not them)
>
> snip
>
> TIA,
> Dave
Received on Wed Oct 27 1999 - 00:21:20 CDT