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 the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
