Re: Memory limit for Win2000 and Oracle 8.1.7

"Jesper Wolf Jespersen" <NOjwjSPAM_at_ehuset.com> wrote in message news:<peGn7.2499$lk7.58669_at_news.get2net.dk>...
> We are in the process of setting up a rather large database running under
> Oracle 8.1.7 and Windows 2000 server(probably advanced server).
>
> In Windows NT 4.0 and Oracle 8.1.7 we had problems with memory. The
> NT-Oracle combination did not support more than 3 GB of memory for a single
> Oracle Instance, which was not enough when there were lots of activity.
> One way of curing that problem on NT4.0 was to reduce the size of the SGA,
> thus freeing up memory for the free memory used bu oracle.
> Another way to cure the problem was to start the second instance up and run
> in OPS configuration, here the SGA could be kept at optimum size while
> stille allowing for all the loose memory, simply since sessions are
> distributed over two physical machines.
> The Oracle homepage talks about 4 GB pr instance, and if NT allows, there
> should be access to 8 GB pr instance.
>
> Now that statement is a bit to loose for my taste, 4 GB wont cut it but 8 GB
> might. Who has experience with this kind of memory allocation in Win2000
> with Oracle 8.1.7 ?
>
> The reason our database uses all that memory is that an awfull amount of
> PL/SQL collections are being used for calculation, and oracle is not so good
> at garbage collection as they want us to believe :-)

I do not want to start flamewars, but I think that if your needs are so extensive, then can be a good idea to switch to another platform. For example with Solaris or HP-UX platform you will have no problem with humble 4 gigs of memory.
My experiences told me that Unix environments are more stable sollution for larger Oracle applications.

--
_________________________________________

Dusan Bolek, Ing.
Oracle team leader

Note: pagesflames_at_usa.net has been cancelled due to changes (maybe we
can call it an overture to bankruptcy) on that server. I'm still using
this email to prevent SPAM. Maybe one day I will change it and have a
proper mail even for news, but right now I can be reached by this
email.