Re: shared server configuration
- From: Stefan Knecht <knecht.stefan@xxxxxxxxx>
- To: maureen.english@xxxxxxxxxx
- Date: Thu, 21 Oct 2010 15:58:01 +0200
Maureen
What platform are you running oracle on ?
We've encountered some really naughty bugs running on hp-ux 11.3 on ia64,
that only manifest under high load (similar number to concurrent connects as
yours), and that completely killed the systems performance.
Stefan
=========================
Stefan P Knecht
CEO & Founder
s@xxxxxxxx
10046 Consulting GmbH
Schwarzackerstrasse 29
CH-8304 Wallisellen
Switzerland
Phone +41-(0)8400-10046
Cell +41 (0) 79 571 36 27
info@xxxxxxxx
http://www.10046.ch
=========================
On Thu, Oct 21, 2010 at 4:22 AM, Maureen English <maureen.english@xxxxxxxxxx
> wrote:
> We're trying to determine the optimal parameter settings
> to allow us to have one of our applications connect to our
> database (10g) using shared server connections.
>
> We currently have processes set to 2000. With only dedicated
> server connections, we have swapping problems when we reach
> about 1800 connections. I've always thought that connections
> and processes were the same thing.
>
> I'm pretty sure I understand the concept of shared servers. I
> see the many shared server connections to the database, and the
> 3 OS processes these connections are using. That looks to me
> like it will definitely solve our swapping problem when we get
> overloaded.
>
> What I'm confused about is whether or not we need to increase
> the value we have for processes. I can see in v$session that
> there are many sessions with the same ospid...which makes sense,
> those are all using the same shared server process.
>
> We don't limit shared server sessions, just the number of shared
> servers. What worries me is that if we have 3000-5000 people
> hitting our application at the same time, how will that affect
> the number of processes?
>
> I've been looking at v$process in our test database, but we don't
> have the volume of users in this database that we have in our
> production database, so it's hard to determine what's happening
> to processes as we increase the shared server sessions.
>
> Any comments/suggestions?
>
> - Maureen
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
Other related posts:
