Oracle has a few options based on enhancing the network. Since I do not have a lot of information regarding specifics, I'll provide a general overview.

If you have not done so already, verify you are using a Shared server and not a Dedicated Server environment. Shared server architecture eliminates the need for a dedicated server process for each connection. Each shared server process serves multiple client requests in the shared server configuration. Shared server processes and dedicated server processes provide the same functionality, except shared server processes are not associated with a specific user process. Instead, a shared server process serves any client request in the shared server configuration.

Consider modifying your SQL to PL/SQL. PL/SQL boosts performance. Using PL/SQL, a tool can do any computation quickly and efficiently without calling on Oracle. This saves time and reduces network traffic.

Oracle Net Services uses the communication protocols or application programmatic interfaces (APIs) supported by a wide range of networks to provide a distributed database and distributed processing for Oracle. After a network session is established, Oracle Net Services acts as a data courier for the client application and the database server. It is responsible for establishing and maintaining the connection between the client application and database server, as well as exchanging messages between them. Oracle Net Services is able to perform these jobs because it is located on each computer in the network. Oracle Net Services provides location transparency, centralized configuration and management, and quick out-of-the-box installation and configuration. It also lets you maximize system resources and improve performance.The Virtual Interface (VI) protocol places most of the messaging burden on high-speed network hardware, freeing the CPU for more
important tasks.

Since its in regards to network traffic, I suggest contacting your Network Admins to help. You should research tools like Web Accelerator or WANJet by F5 Networks. Nice thing is they are the only network company that have a plug-in that will work with 10gR2 Enterprise Manager Grid Control. Since its in regards to network traffic, you'll have to contact your Network Admins to help.

LS

"640KB ought to be enough for anybody." - Bill Gates, 1981

Oracle LazyDBA home page