Re: Scaledown hardware

Sorry for the replies guys, I had a small accident and was in hospital for a few days.

Niall, yes there are around 30 active users and they do consume around 9 CPUs. This is Siebel, RBO used and 50 table joins so there are queries with massive consistent gets so CPU usage. The DR Box will support 30% Users, limited at application level.

Thanks all for your comments, appreciated. Will read them carefully.

Alex

On 9/24/06, Niall Litchfield <niall.litchfield_at_gmail.com> wrote:
>
> Do you really mean that 30 active sessions eat 70% of 12 cpus, i.e 9
> cpus? And how many concurrently active users would your dr box
> support? My best guess it would be most of those 30 wouldn't it? If so
> You'd be mad to choose anything other than an identically specced box.
> If on the other hand you actually intended 300 concurrent users and
> the dr box would only be supporting far fewer then you'd likely get
> away with fewer cpus.
>
> On 9/22/06, amonte <ax.mount_at_gmail.com> wrote:
> > Hi
> >
> > I am sizing a server for a database which will be used for disaster
> > purposes. It should support 25% of production load.
> >
> > Right now I have a production server with 12 CPU and 48Gb memory, in
> peak
> > time 70% of CPU usage is observed (30 Active database users) and 40GB is
> > used. This supports 3600 users roughly.
> >
> > Is this that simple divide my actual HW by 4? i.e 3 CPU and 12 GB to
> support
> > 1200 users? I think I can do that for memory but not that sure for CPU
> > usage.
> >
> > TIA
> >
> >
> > Alex
> >
> >
>
>
> --
> Niall Litchfield
> Oracle DBA
> http://www.orawin.info
>

--
http://www.freelists.org/webpage/oracle-l