79679

79679



About Server and Client Processes

In addition to background processes, Oracle Database crcates server processes that handle the connection rcquests of user or client processes. A user connection is composcd of the following distinct picces:

■A client program acting on behalf of the user, such as Oracle Enterprise Manager (Enterprise Manager), SQL*Plus, or an application

■A scrver process that handlcs the connection to the database on behalf of the client program, and that performs much of the work for the client program, such as parsing and running SQL statements, and retrieving and returning results to the client program

Server processes can be either dedicated or shared. When server processes are dedicated, Oracle Database is running in dedicated server modę. When server processes are shared. Oracle Database is running in shared server modę. In dedicated server modę. each client process has its own server process. Although a dedicated server process is good for long-running queries and administrative tasks, an idle process or too many dedicated processes can result in an inefficient use of resources. Using shared server modę eliminates the need for a dedicated server process for each user connection, requires less memory for each user connection, and enables morę users to access the database. Shared server modę is morę efficient at supporting multiple client programs making frequent short-running queries.



Wyszukiwarka

Podobne podstrony:
P1130015 (2) 1.2.4 Follicular and ovarian hematomas In addition to the luteinizing. anovulatory foll
Scheduling Miscellaneous Backup Tasks In addition to implementing thc Oracle suggestcd backup stratc
page40 NUT-AND-LEAF BRACELET This bracelet, inspircd by naturę, features tiny bead nuts in addition&
MySQL Community Support on Internet Relay Chat (IRC) In addition to the various MySQL mailing lists
IMG10TXT In addition to these Release 13 products, The MathWorks and third-party partners supply man
img11txt In addition to these Releose 12 products, The MothWorks and third-party partners supply man
10 summary text In addition to these R12 products, The MothWorks and third-porty partners supply man
00169 ?8fdc7697ba8e0e2234fcfe61c09204 170 McWilliams satisfy ^3 = r/0 = T] + T2. In addition to exa
Folia Medica Lodziensia, 2011, 38:177-200Current view about basophils and their significance in the
17.7.2000 lENl Official Journal of the European Communities L 178/11 2. In addition to other in
17.7.2000 lENl Official Journal of the European Communities L 178/11 2. In addition to other in
image002 SOMETHING NEW IN 1 0 • • U 1 i 0 In addition to a fuli score of the very best in new sc
Administering the Database with SQL-Based Management Tools In addition to using the graphical user i
libmemcached Command-Line Utilities In addition to the main C library interface, libmemcached also i
and our Canadian friends for giving us the opportunity to go and see them in Canada, to see the wond
95 (145) attained. It may be necessary to stretch the muscles and other structures in order to lock
stormB5 [EX PLORE MORĘBirth of a Hurricane A. Preview. Combine the suffixes in the box and the words

więcej podobnych podstron