Which to use Shared Server or Connection Pooling?
299008May 6 2006 — edited May 6 2006Hi,
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.