Oracle listener-Introduction to configuration of shared connection Parameters

Set the database to start several dispatcher (start three dispatcher)

SQL> alter system set dispatchers = '(protocol = tcp) (dispatchers = 3 )'

Set the maximum number of dispatcher instances that can be started in the database at the same time (define to start up to five dispatcher instances). Even if the dispatchers parameter is used to define more than five dispatcher instances, only five dispatcher instances can be started.

SQL> alter system set max_dispatchers = 5;

Set to start several Server Processes

SQL> alter system set shared_servers = 5;

Server processes can be dynamically generated as needed. If shared_servers is set to 0, server processes will be automatically deleted once used. Therefore, we should create fewer server processes. If not, the system automatically creates additional server processes based on the load. The number of server processes automatically created at the same time is determined by the other initialization parameter max_shared_servers.

Set the number of server processes automatically created by the system based on the Load

SQL> alter system set max_shared_servers = 20;

At this time, the database will run five server processes by default. When the database load increases and additional server processes are required, server processes will be automatically created, and a maximum of 20 server processes can run simultaneously, when the database load drops, the server process will be automatically deleted until the remaining five server processes exist.

Sets the number of sessions that can use the shared connection. (This parameter specifies the number of sessions that can be used for shared connections)

Alter system set shared_server_session = 100

The number of sessions that can use the dedicated connection is the value of the initialization parameter session minus shared_server_session.

Specify the shared connection mode (SERVER = shared) in the tnsnames. ora file)

Verify whether a shared connection is successfully established

[Oracle @ tyger admin] $ lsnrctl service

SQL> select USERNAME, SID, SERVICE_NAME, SERVER, PROGRAM from v $ session where USERNAME = 'sys ';