Re: Resource consumption in windows 2000

I did not have two versions installed, I just have two versions too choose between. When I just want to be able to use sqlplus which installation do i need then and which version of oracle (8i PE or 8i EE) and minimum, maximum or custom?

Nice regards Kim Eichen

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> skrev i en meddelelse news:tc25juis4msoef_at_beta-news.demon.nl...
>
> "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 - 19:42:09 CST