Re: Shared Server configuration on a datawarehouse

From: NetComrade <netcomradeNSPAM_at_bookexchange.net>
Date: Wed, 13 Sep 2006 04:18:09 -0400
Message-ID: <6hffg29clcsbu06pgujepricq41j0avptc@4ax.com>

On Fri, 08 Sep 2006 00:13:04 GMT, "Dereck L. Dietz" <dietzdl_at_ameritech.net> wrote:

>I'm working with a datawarehouse using Oracle 10g R2. Our DBA said he was
>using shared servers instead of dedicated servers because of the amount of
>connections we have. He then went on to say the max connections we've had
>has been 40.
>
>Is having a maximum of 40 connections cause to user a shared server for a
>datawarehouse?
>

Ask your DBA why. He probably won't have a good answer. He he says connections use 'too much memory', you have either a purely tuned sort_area_size, pga_aggregate_size, or an idiot dba that thinks that each dedicated process consumes as much memory as oracle's SGA.

.......
We run Oracle 9iR2,10gR1/2 on RH4/RH3
remove NSPAM to email Received on Wed Sep 13 2006 - 03:18:09 CDT