Dedicated and shared modes of Oracle)

1. Whether it is configured as a shared server. The most important parameter is
8i mts_servers
9i shared_server
Show parameter shared_server mts_servers
If the value is greater than 0, the Shared Server is enabled.

2. When configured as a shared server, the client can connect to the database using a Shared Server or a dedicated server. The control of this parameter is set in tnsnames. ora.
Aaaa =
(Description =
(Address_list =
(Address = (Protocol = TCP) (host = AAAA) (Port = 1521 ))
)
(CONNECT_DATA =
(SID = aa)
(Server = dedicated)
)
)
The red part specifies the dedicated method to connect to the DB.
In addition, background process, and locally connected, can only be dedicated
For example, sqlplus user/pass
If the DB is not configured with a shared server, the client can only connect to the DB in dedicated mode.

3. There are two methods to determine the connection mode of a connected session.
A
Select Server from V $ session
Where...
If Server = 'dicated ', it is in dedicated mode.
Server = 'shared 'is the shared mode, and shared_server_process is serving it.
Server = 'none' is shared and no shared_server_process service is available.

B. It is only used under Unix. It seems that unknown does not work.
Connect to V $ session, V $ process to view the program in process
1 select P. Program, S. server from V $ session S, V $ PROCESS p
2 * Where S. paddr = P. ADDR
If program is .. (S0nn), it is shared, and shared_server_process is serving it
If program is .. (D0nn), it is in the shared mode, and currently no shared_server_process serves it
If the program is other, it is in the 'dedicated 'mode.

(Original: http://www.cublog.cn/u/20078/showart.php? Id = 127802)