O'Reilly logo

Expert Oracle RAC Performance Diagnostics and Tuning by Murali Vallath

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required