Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL Performance Degrades Severely in WAN

168975Feb 7 2003 — edited Feb 11 2003

The Oracle server is located in the central LAN and the client is located in the remote LAN. These two LANs are connected via 10Mbps wide network. Both LANs are of 100M bps inside. If the SQL commands are issued in the same LAN as Oracle server is located in, the speed is fast. However, if the same commands are issued in the remote LAN, the speed is degraded severly, almost 10 times slower. There are only a few results returned by these SQL commands. My questions are the reason of this performance degradeness and how to improve the performance in the remote client.
The server is Oracle817 and OPS, and the SQL commands are issued in PB programs in the remote client.
Thanks very much.

Locked Post

New comments cannot be posted to this locked post.

Locked on Mar 11 2003

Added on Feb 7 2003

#general-database-discussions

7 comments

530 views