Occasionally asked about the database in shared mode and dedicated mode differences, there is some ambiguity, it is to do something different analysis:
MTS (multi-threaded services) and the difference between special modes:
Private Mode is a dedicated server process for the client to do one on one treatment process, the client process (no matter what the program connects to the database) will be directly in such as TCP / IP socket number of words that the network pipe, with the dedicated server connection.Buffer pool data to find data, processing sql.
MTS model is replaced by a dedicated shared service process model the process of dedicated service.Client process will be the first to be allocated by the distributor dispatche process client requests to the SGA in the request queue, and then by the process to bring up the shared services and process, the result (data, return code, etc.) into the response process by sharing servicesto the response of the column, waiting for the process to send the distributor to the client process.
When we launched the
sqlplus scott / tiger @ tns
Where tns is the TNS service name, tns Representative (transparent network substrate), which is built in oracle client 'platform' software, which handles remote connections - which allows such communication.Oracle TNS connection string to tell the software how to connect to a remote database.In general, running the client software on the machine will read tnsname.ora file.
tns =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP) (HOST = jimmypeng) (PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = test)
)
)
Through this document, the client software knows who you want to connect, it will open the 1521 port to connect the server jimmypeng the tcp / ip socket connection.