Which to use Shared Server or Connection Pooling?

[stevenpannell]

Hi,

I need to upscale our system to support more users / applications. We are using dedicated server. I have 150+ connections now and need to add 150 more. I see that I have 2 options:

1. Oracle Shared Server.
2. 2nd level tier connection pool (some software solution I have not decided upon yet).

My question which solution would you recommend?

Typically my users /apps run queries < 10 secs but sometimes the SAME users will run a 30-60 second query.

Sharer Server looks like a good 'free' option as I use Oracle 10g EE. But perhaps not the best solution.? Any advice would be helpful.

Thanks!
Steve.

[davey23uk]

or leave it as dedicated. Shared server isnt too popular anymore for some reason - there is a performance penalty with it.

I would suggsty a connection pool in your app server with dedicated processed. 300 connections isnt really a lot and you are going to save yourself a lot on connection times if you do that