Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Resource consumption in windows 2000
I would choose 8iEE.
You can set an Oracle instance to manual startup using the oradim command line utility. Equally you can set all the Oracle services to manual startup using the services utility in computer management.
As for memory use the main parameters to look at in the init.ora file are
DB_BLOCK_BUFFERS * DB_BLOCK_SIZE (gives the size of the buffer pool)
JAVA_POOL_SIZE. (set it to 1M).
SHARED_POOL_SIZE
on a personal system you can set these quite low.
-- Niall Litchfield Oracle DBA Audit Commission UK "Kim Eichen" <eichen_at_worldonline.dk> wrote in message news:Otaw6.2002$94.446518_at_news010.worldonline.dk...Received on Fri Mar 30 2001 - 03:43:59 CST
> 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
> >
> >
> >
> >
>
>
![]() |
![]() |