Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: To much memory for...
I think he just needs to take a happy pill today. He's suffering a deranged
belief that people will/should read the 10,000 pages of documentation before
working with oracle.
Anyway, you can reduce the memory requirement enormously by changing the init.ora parameters.
Unfortunately, I don't have oracle and documentation in this environment. There is an initialisation file, normally in something like c:\oracle\admin\<database name>\pfile\init.ora
This file can be edited with notepad. Based on the sample file, you can save quite a lot of memory.
The main entries affecting memory usage are:
db_block_buffers =
Amount of memory = block size (normally 8k) * db_block buffers used for
caching data read from the database. This can be set quite low, eg 200
shared_pool_size = <size in bytes> 10485760 = 10M, you might be able to
get down to 5M
Used for parsing statements, caching data dictionary tables.
java_pool_size =
Used by java, default 20m, set to minimum value (1000000) if not using java.
"Andre Vaupel" <avaupel_at_web.de> wrote in message
news:eT108.18447$P31.316127_at_news.easynews.com...
> Hi!
>
>
> Thanks for the helpful answer :-/ But guess you were a beginner as well in
> the past, isnīt it?
> Or did you start as a professionell first?
>
>
> Andre
>
>
>
> "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> schrieb im Newsbeitrag
> news:h1a14ucm558a0knvodgtqnr1ljk12999el_at_4ax.com...
> > On Sat, 12 Jan 2002 20:33:05 GMT, "Andre Vaupel" <avaupel_at_web.de>
> > wrote:
> >
> > >...a notebook what i need to build some simple query on websites etc.
> > >
> > >
> > >Is there any possiblity to decrease the hungry of memory from Oracle
> 8.1.7 ?
> > >I need only one table and basic funtions....but Oracle takes around
> 80-120
> > >MB
> > >of memory...is there anything what i can do to limit the usage of the
> > >memory?
> > >
> > >
> > >
> > >Thanks a lot!
> > >
> > >
> > >Andre
> > >
> > >
> > >
> > Stop using it.
> >
> > Hth
> >
> > Sybrand Bakker, Senior Oracle DBA
> >
> > To reply remove -verwijderdit from my e-mail address
>
>
Received on Sat Jan 12 2002 - 19:06:34 CST