Re: Oracle 8.1.7 on Windows 2000 2g per process memory limit

"Chuckster" <chuckycarson_at_networkcloud.com> wrote in message news:3DD2F96A.9080807_at_networkcloud.com...
>
> What do yo mean upgrade your OS? What will support more than 2gb per
> process besides UNIX?

Got it in one. Or maybe Advanced Server. Or maybe DataCentre Server. I'm not entirely "up" on the Windows family behaviour... but I believe it gets better the more money you pay (strange, that.)

>We have this same problem, we are mostly Unix but
> do have 2 Oracle databases on Windows 2000. We currently ar stuck at a
> 1.7gb SGA running 8.1.7.3 on Windows 2000 SP2.
>

That's an awful big SGA. I had a client the other week state emphatically that they needed a 4GB SGA. I couldn't refute the suggestion, because that would require hands-on experience and testing, which I wasn;t going to get the opportunity to do. But I'll bet my bottom dollar it's not needed.

Regards
HJR
> -Chuck
>
>
> Howard J. Rogers wrote:
> > No.
> >
> > So if that's a real problem for you, it's time to either (a) upgrade
your OS
> > or (b) look into RAC -Real Application Clusters.
> >
> > Regards
> > HJR
> >
> >
> > "Tom Dyess" <nospam_at_nospam.spm> wrote in message
> > news:25AA9.51088$842.18111_at_news1.fdn.com...
> >
> >>Is there any way around the Oracle 8.1.7 on Windows 2000 Server's 2 gig
> >
> > per
> >
> >>process memory limit? Either break oracle connections into multiple
> >>processes or configure Windows 2000 Server (Not advanced) to allow more
> >
> > than
> >
> >>2 gigs per process?
> >>
> >>Thanks,
> >>Tom
> >>OraclePower.com
> >>
> >>
> >
> >
> >
>
>
>
> -----------== Posted via Newsfeed.Com - Uncensored Usenet News
==----------
> http://www.newsfeed.com The #1 Newsgroup Service in the World!
> -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers
=----- Received on Wed Nov 13 2002 - 19:34:00 CST