Chapter 39

SQL*Net Diagnostics and Performance Tuning

Serg Shestakov

Dmitry Petrov

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 ...

Get Oracle Internals now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.