Home » RDBMS Server » Server Administration » dedicated or shared server
icon4.gif  dedicated or shared server [message #201208] Fri, 03 November 2006 01:30 Go to next message
deni_sa
Messages: 77
Registered: June 2006
Member
Hello,
I have an application that uses oracle shared server, but the application uses tables with a lot of records and is uses by many users.It is slow and I don't know if it will make a difference if the oracle database is shared or dedicated server.Can you help?
Denisa
Re: dedicated or shared server [message #201394 is a reply to message #201208] Fri, 03 November 2006 22:56 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi denisa
Dedicated Server :-
The user and server processes are separate, distinct processes. The separate server process created on behalf of each user process is called a dedicated server process (or shadow process), because this server process acts only on behalf of the associated user process.

This configuration maintains a one-to-one ratio between the number of user processes and server processes. Even when the user is not actively making a database request, the dedicated server process remains (though it is inactive and can be paged out on some operating systems).

[b]
Dedicated server architecture can sometimes result in inefficiency. Consider an order entry system with dedicated server processes. A customer places an order as a clerk enters the order into the database. For most of the transaction, the clerk is talking to the customer while the server process dedicated to the clerk's user process remains idle. [I]The server process is not needed during most of the transaction, and the system is slower for other clerks entering orders. For applications such as this, the shared server architecture may be preferable.[/I]
[/b]

Dedicated and Shared Servers
Memory allocation depends, in some specifics, on whether the system uses dedicated or shared server architecture. Table 8-1 shows the differences.

Table 8-1 Differences in Memory Allocation Between Dedicated and Shared Servers

Memory Area Dedicated Server Shared Server 
Nature of session memory
 Private
 Shared
 
Location of the persistent area
 PGA
 SGA
 
Location of part of the runtime area for SELECT statements
 PGA
 PGA
 
Location of the runtime area for DML/DDL statements
 PGA
 PGA
 

*****************
Shared Server Architecture
Shared server architecture eliminates the need for a dedicated server process for each connection. A dispatcher directs multiple incoming network session requests to a pool of shared server processes. An idle shared server process from a shared pool of server processes picks up a request from a common queue, which means a small number of shared servers can perform the same amount of processing as many dedicated servers. Also, because the amount of memory required for each user is relatively small, less memory and process management are required, and more users can be supported.

A number of different processes are needed in a shared server system:

A network listener process that connects the user processes to dispatchers or dedicated servers (the listener process is part of Oracle Net Services, not Oracle).

One or more dispatcher processes

One or more shared server processes

Shared server processes require Oracle Net Services or SQL*Net version 2.



[b]
Note:- Dedicated Server processes best for minimum no. of users.
and idle time afordable. or shared server better for maximum usage of resources. ( no idle time).

If server configured for "shared server". the problem is not bcoz of Configuration of server.

Generate Statpack report and analyiz.
May be statpack report help you for findout ur problem.


Hope this helps.
Taj

[Updated on: Sat, 04 November 2006 00:53]

Report message to a moderator

Previous Topic: How to find out my oracle9i run in mts mode/dedicated mode?
Next Topic: Conflicting database timestamp
Goto Forum:
  


Current Time: Sun Dec 04 04:34:34 CST 2016

Total time taken to generate the page: 0.09793 seconds