CHAPTER 11

image

Tuning Oracle Net

In an n-tier architecture solution, each tier connects to the other via a network component. An Oracle database that normally resides on the database tier provides connectivity via a network layer.

Oracle application systems use an SQL Net interface between the Oracle application software and the underlying network protocol layer. By using these interface layers, users accessing the database are able to access, modify, share, and store data.

There are two phases when the user accesses the database to retrieve or store the data: the connect phase and the query phase. The connect phase is where the application server ...

Get Expert Oracle RAC Performance Diagnostics and Tuning 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.