Re: a sad story for Oracle DBAs

From: Jonathan Gennick <gennick_at_worldnet.att.net>
Date: 1998/04/03
Message-ID: <6g3k2k$mp0@bgtnsc03.worldnet.att.net>#1/1

On 3 Apr 1998 16:56:24 GMT, zhen_at_wam.umd.edu (Zhencan Fan) wrote:

>One prestigious consulting company is going to deliver an Oracle
>data warehousing system for a client. Here is the hardware configuration:
>Windows NT 4.0 running on quad pentium pro 200
>896 MB RAM
>About 50 GB Harddrive space
>
>Guess how much memory they assigned for SGA: 18MB!

Ok, it's dumb question time. I have to set up Oracle on an NT machine next week, and this very issue is one that I've been wondering about. The target machine has 128meg ram. Is there an NT utility that will tell me how much of that is left after the OS loads? My machine is also going to be dedicated to Oracle, and I want to set the SGA as large as possible. How do I know how large I can go?

Jonathan Received on Fri Apr 03 1998 - 00:00:00 CST