-
Oracle/VB application is very slow over WAN
Hi,
We have a oracle8i database in a remote location and is responding very slowly. In the LAN the response is pretty good. We have 8 T1 lines between these two locations. tnsping response from the remote location is 120 msec. could you provide tips in troubleshooting the network problem.
-
Do you cache any of the data within the VB program? Do you have refresh events that are causing a lot of data to get pushed down to the client? Have you done any sqlnet tracing to see how much data get pushed down to the client? I would start there and see what happens.
-
Have you adjusted your prefetch size?
Jeff Hunter
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|