Re: Resource consumption in windows 2000

"Kim Eichen" <eichen_at_worldonline.dk> wrote in message news:U%5w6.1517$94.378874_at_news010.worldonline.dk...
> The reason why I cant be so specific about oracles resource consumption is
> that I have uninstalled oracle because of the big resouce consumption. You
> mention the excel case and that is actually how I want it. I dont mind if
> oracle uses a lot of ram when I am running oracle. What I mind is that
> oracle consumes resources whether I am using oracle or not. My system
 setup
> is:
> 1200 thunderbird
> 512 mb ram
> 2* ibm 75gxp 46,1 gb harddisks in a striped array
> 1* ibm 34gxp 34 gb only used for backup
> When I start windows 2000 without oracle the ram consumption is like 100
 mb
> and when oracle is installed allocated memory is something like 400-450
 mb.
>
> Regard Kim Eichen
> by the way, thanks for responding so fast
>
> "Kim Eichen" <eichen_at_worldonline.dk> skrev i en meddelelse
> news:Kn%v6.1079$94.307374_at_news010.worldonline.dk...
> >
> > I have oracle 8i Pe and oracle 8i EE and I am using windows 2000. When I
> > have installed any of the oracle databases it drains my computer for
 ram.
 Is
> > there a solution for this?, something oracle doesn't start until I
 actually
> > want to use the database As it is now (or before I uninstalled it)
> > oracle.exe starts with windows and uses 97 mb ram.
> >
> > Is there anybody who has a solution?
> >
> >
> >
> > Nice regards Kim Eichen
> >
> >
>
>

If you don't want Oracle to use so much memory, you can - shut it down when you don't use it (1 single command) - make sure several init.ora parameters have been set appropiately. Please post or e-mail the
results from
select * from v$sga
and
select * from v$sgastat
and include the output of
show parameters

You must be connected as SYS or internal to do this.

I'm sure you have some incredible parameter settings. Oracle simply doesn't use that much memory when properly tuned.

Also, of course one version of Oracle should have been enough and you definitely shouldn't have them running together. Hopefully that's not the reason why Oracle is using so much memory but I am afraid it is: you have two instances, two databases, and two sga's

Regards,

Sybrand Bakker, Oracle DBA Received on Tue Mar 27 2001 - 14:07:29 CST