RelationalDBDesign RelationalDBDesign


Network Config   «Prev  Next»
Lesson 9 Using SQL*Net with multi-protocol functionality
Objective Use SQL*Net with connections to Multiple Protocols

Using SQL*Net with multi-protocol Functionality

Oracle Connection Manager provides multiple protocol support, enabling a client and server with different networking protocols to communicate with each other.
This feature replaces functionality previously provided by the Oracle MultiProtocol Interchange in SQL*Net version 2.
Net8 can traverse as many networking protocol stacks as can be installed and supported. In fact, the number of networking protocols supported is limited only by those restrictions imposed by the specific node's hardware, memory and operating system.
The figure below shows how a client in an SPX/IPX network can route its session to a server over a TCP/IP transport through to the Connection Manager.


Oracle Connection Manager

Each connection to the database takes up valuable network resources, which can impact the overall performance of a database application. Oracle’s Connection Manager (CMAN), illustrated in Figure 6-9, reduces the number of Oracle Net client network connections to the database through the use of concentrators, which provide connection multiplexing to implement multiple connections over a single network connection. Connection multiplexing provides the greatest benefit when there are a large number of active users.

Concentrators with Connection Managers
Figure 6-9: Concentrators with Connection Managers for a large number of users

You can also use the Connection Manager to provide multiprotocol connectivity if youstill have some clients and servers not using TCP/IP. Oracle Database 10g introduced dynamic Connection Manager configuration, enabling the changing of CMAN parameters without shutting down the CMAN process.
The next lesson concludes this module.