Re: Disadvantages of Shared Server

From: Alex Filonov <afilonov_at_yahoo.com>
Date: 5 Jan 2005 20:56:47 -0800
Message-ID: <1104987407.935734.79930@c13g2000cwb.googlegroups.com>

Dave 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?
>

Spend a little bit of money and buy Tom Kyte's book "Effective Oracle by
Design". It has a very good article on shared server.
>From my experience: Make sure that you have big enough SGA to
accomodate
all sessions PGA.

> Regards,
> Dave
> widsith_at_panix.com
Received on Wed Jan 05 2005 - 22:56:47 CST