Dedicated Server Processes
A dedicated server process services only one user process.
Figure 5-1 illustrates how dedicated server processes work. In this diagram two user processes are connected to the database through dedicated server processes.
red hat certified system administrator rhcsa malaysia
In general, it is better to be connected through a dispatcher and use a shared server process. A shared server process can be more efficient because it keeps the number of processes required for the running instance low.
agile project management certification training courses malaysia
In the following situations, however, users and administrators should explicitly connect to an instance using a dedicated server process:
To submit a batch job (for example, when a job can allow little or no idle time for the server process)
To use Recovery Manager (RMAN) to back up, restore, or recover a database
To request a dedicated server connection when Oracle Database is configured for shared server, users must connect using a net service name that is configured to use a dedicated server. Specifically, the net service name value should include the SERVER=DEDICATED clause in the connect descriptor.
red hat certified specialist in red hat enterprise Linux diagnostics and troubleshooting malaysia
Comments
Post a Comment