Re: To much memory for...

Actually I'm sure that Sybrand is merely suffering from the deranged belief that people will

1. Read the 500 or so pages of the Concepts manual.
2. Consider the appropriateness of the tools they have for the job at hand.

I must admit this is more of a hope for me now than an expectation.

FWIW I would never recommend Oracle (even lite) for single table databases on a laptop. Access pretty much has that market sewn up.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************
"Keith Boulton" <kboulton_at_ntlunspam-world.com> wrote in message
news:F0508.8389$_x4.1045697_at_news2-win.server.ntlworld.com...


> 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

> >

> >

>

>