Oracle Distributed Systems

SQL*Net/Net8 Tuning

The most effective network tuning you can do for SQL*Net/Net8 is to reduce the number of round-trip messages between the client machines and database server. You can control this behavior in various ways, such as setting your application’s ARRAY_SIZE (the number of records that are processed with each fetch), the size of the session data unit (SDU), and the use of stored procedures. In addition, scalability issues can be improved by tuning your MTS configuration. Net8 introduces additional multiplexing and connection pooling capabilities which scale to support tens of thousands of users.

Do You Have a Problem?

The first step in addressing SQL*Net/Net8 scalability is to recognize whether your system is experiencing a performance degradation and act accordingly. If you are using multi-threaded server, your primary concerns are whether the dispatchers are keeping up with the rate of requests and whether the server processes are able to handle the volume of activity. If you are using prespawned servers, your concerns are whether you have enough servers and whether the machine has the resources to accommodate their memory and CPU usage. Methods of diagnosing all of these situation are included here.

Tuning the multi-threaded server

Tuning the multi-threaded server amounts to configuring more dispatchers and adding or reducing server processes. The book Oracle Performance Tuning, 2nd edition, by Mark Gurry and Peter Corrigan (O’Reilly & Associates, 1996) includes SQL ...