Re: Prespawning processes on dedicated server (8i)

From: Holger Baer <holger.baer_at_science-computing.de>
Date: Tue, 28 Jun 2005 13:45:52 +0200
Message-ID: <d9rd9g$f8k$1@news.BelWue.DE>

Billy wrote:
> Ramon Poca wrote:
>

>>Hi there,
>>
>>We're running on 8i (Solaris64) (I know, I know, upgrade :-P) with
>>dedicated server.
>>
>>Question is: Running against an application server which uses its own
>>connection pooling, can we benefit from prespawning servers on Oracle,
>>to avoid the process creation cost?

>
>
> Yes. MTS (aka Shared Server) lowers the process footprint of client
> session service processes on the db platform. Which means that a
> relatively small pool of shared processes can service a large number of
> client sessions. Now whether these sessions are app server pooled
> connections or traditional client connections.. Oracle does not know
> the difference. Does not care. And does not need to know or care.
>
> Just remember that you scale the database in Oracle. Period. More app
> servers, app server processing pools, etc. do not make the database
> perform faster or scale better. (which of course shows just how far up
> their asses J2EE peoples' heads are)
>
> --
> Billy
>

If the application server uses connection pooling, then there shouldn't be constantly new connections be made and old ones closed. Which in turn should result in a small pool of connections.

Pooling a pool is not a good idea in my book.

Regards
Holger Received on Tue Jun 28 2005 - 06:45:52 CDT