OracleDBA Shared Server tutorial, oracledba tutorial

OracleDBA Shared Server tutorial, oracledba tutorial

Configure the Shared Server as follows:

1) The name of the Shared Server connection is S_P124094 ",

2) connection information:

3) -- the protocol is "tcp ",

SQL> alter system set dispatchers = '(PROTOCOL = TCP) (serve = Database Name)'; // NETWORK SERVICE name

4) -- The host name is "127.0.0.1 ",

5) -- The Connection port is 1522,

6) parameter settings:

7) -- at least 625 users can be shared ,----------------

8) -- set the initial number of processes on the shared server to 3,

9) -- set the maximum number of processes on the shared server to 7.

Lab procedure

1. Net Manager

2. 8)

3. 6)

4. 3)

5. $ lsnrctl stop/status/start

Check whether the set parameters take effect

Show parameter shared_servers

Show parameter disp

Select * from v $ shared_server;

Select * from v $ dispatcher;

The listener should be started after the service is started.