Re: Disadvantages of Shared Server

From: NetComrade <netcomradeNSPAM_at_bookexchange.net>
Date: Wed, 05 Jan 2005 19:44:26 GMT
Message-ID: <41dc4360.4148058512@localhost>

try not to run batch jobs in shared server there is a slight overhead, that you probably won't notice in shared server
look into large_pool parameter for MTS

On Wed, 5 Jan 2005 11:19:03 -0500, "Dave" <Nospam_at_PublicAccessuNIX.com> wrote:

>OK, After experiencing random ORA-12500 errors, we discovered that we had
>too many connections on our 9i Oracle Server (Win2K) and implemented Shared
>Server to correct. So far this has had a very beneficial effect on our
>system.
>
>That being said, my question here is what, if any, are the possible
>disadvantages to using Shared Servers? Is there anything I should keep my
>eye out for, something likely to be adversely affected?
>
>Regards,
>Dave
>widsith_at_panix.com
>
>

.......
We use Oracle 8.1.7.4 on Solaris 2.7 boxes remove NSPAM to email Received on Wed Jan 05 2005 - 13:44:26 CST