ABSTRACT
Network diagnostics and performance tuning are important issues to consider for savvy administrators managing complex distributed Oracle installations. Oracle has many powerful features for SQL*Net diagnostics, such as logging and tracing mechanisms, explanation tools, and statistics collection. To optimize network performance, administrators should accurately tune Oracle SQL*Net services. There are many external and internal factors influencing SQL*Net performance. This chapter considers how to tune SQL*Net buffer size, how to speed up connections for dedicated and multi-threaded servers, what is listeners load balancing; and we will also learn new Net8 features affecting SQL*Net diagnostics and performance. We use the SQL*Net term to describe both Net8 software and older versions, starting with SQL*Net 2.3.x. We also use Oracle utility names for UNIX systems.
