Re: Oracle Shared Mode for Asp.net

> >Is there a good reason why not to use Shared mode? Considering the
> >Asp.net/Web typical behaviour.
>
> There are many good reasons.

> 1 200 sessions shouldn't be a problem

Thats just for the web applications, all together we have 400+ connections. Web connections are expected to increase around 10 times in the next few months. Connections that are not from the web, are usually long queries.

> 2 shared server is unsuited for long running queries

As described, its asp.net application, short queries, most of the sessions idle.

> 3 shared server has overhead.

Given the fact that the memory the processes are allocating are making AIX use the swap, is the overhead not worth trading over swapping?

Also, one has to consider having hundreds of processes vs. a few, transfers the overhead to the OS kernel (context switches to start with).

>
> >Why do, not one or two, but a few dbas insist in believing Dedicated
> >is the only way you should use oracle.
>
> With a number of connection as low as 200 there should be little
> reason for shared server.
>
>
>
> >By the way, anyone has any AIX tips, is it just me or is AIX a pain!?
>
> It is you. Apart from that, either you or your developers, or both
> parties don't have a clue about Oracle. You are thrashing the system
> by setting the SGA way too high (See your other post).
>
>
>
> >Thanks in advance,
> >Cablito
>
> No thanks.
>
> --
> Sybrand Bakker
> Senior Oracle DBA
Received on Sun Jun 17 2007 - 16:07:58 CDT