Dedicated server vs Shared Server

[vr76413]

Hello all...

I created a Test DB in Oracle 9.2 in dedicated server environment. I know that we can also DB in shared server process...

Under which circumstances should i pick Dedicated server and which circumstances should i pick Shared ?...

Thanks
Ron

[slimdave]

got thousands of users on an oltp sytem? Use Shared.

got a DW or DSS system, or an OLTP system with hundreds of users? use dedicated.

[Turin]

If you have a lot of concurrent connections to your database is a good option to use a shared server environment because the performance is improved. In a dedicated server configuration, one dedicated server process attend only one user connection meanwhile in a shared server configuration a shared server process can attend many user connections by using threads. So, a shared server process that use threads to attend many connections waste lower than memory that a configuration where each dedicated process attend one user connection.

Regards.

[slimdave]

You must remember how the shared server achieves this memory-saving effect. it simply blocks sessions from doing anything -- it chokes performance. That is why it is not recommended on systems with long-running queries (DW/DSS, or for batch jobs on OLTP). So performance is actually degraded under a shared server environment, not boosted.

[Shestakov]

Use the simple rule:
-- if u can run oracle instance WITHOUT swaping in dedicated server mode u should to do that
-- if not, u may try to change dedicated server to MTS and
check perfomance before and after
-- than u have to make ur decision

[kris109]

More users than number of available server processes -- Use shared server configuration.

More or less same number of users as server processes -- Use dedicated server configuration.