"A server process can be either a dedicated server process, where one server process services only one user process, or if your database server is configured for shared server, it can be a shared server process, where a server process can service multiple user processes.
"
Все верно, но здесь не сказано что в режиме MTS нельзя использовать dedicated
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
9 - 10 Net8 Administator’s Guide
Overriding MTS on Clients
If the database is configured for MTS and a particular client requires a dedicated
server, the client can be configured to use a dedicated server in one of the following
ways:
n A net service name can be configured with a connect descriptor that contains
(SERVER=DEDICATED) in the CONNECT_DATA section. For example:
sales=
(description=
(address=(protocol=tcp)(host=sales-server)(port= 1521 ))
(connect_data=
(service_name=sales.us.acme.com)
(server=dedicated)))
n The client profile (sqlnet.ora file) can be configured with USE_
DEDICATED_SERVER=ON. This adds (SERVER=DEDICATED) to the
CONNECT_DATA section of the connect descriptors the client uses. For
example:
use_dedicated_server=on
Note: If USE_DEDICATED_SERVER is set to ON, existing
(SERVER=value) entries are overwritten with
(SERVER=DEDICATED).
to Violina: я советую вам всё-же слушать что говорит killed
