Re: Memory usage (newbie)

"John M." wrote:

> My values are much more bigger, but how can I change this values? (I use
> only a trial version from oracle web site.)
>
> Thanks!
>
> "Daniel Morgan" <dmorgan_at_exesolutions.com> az alábbiakat írta a következo
> hírüzenetben: 3D0E3A86.8F596E39_at_exesolutions.com...
> > "John M." wrote:
> >
> > > Hi,
> > >
> > > I want to test my application with an oracle database. I have installed
> an
> > > Oracle 8i server to my computer and I wanto to use it only on local PC.
> But
> > > my system use about 400Mb RAM. Is it possible to decrease it?
> > >
> > > Thanks!
> > > John
> >
> > If you are saying that Oracle is using 400MB RAM you have definitely
> grabbed
> > far more memory than is necessary. I run 8i, easily, in 64MB RAM using the
> > following initSID.ora parameters.
> >
> > db_block_buffers = 2048
> > shared_pool_size=7680000
> > java_pool_size=65536 (and it could be 32K)
> > log_buffers=32768
> > sort_area_size=65536
> >
> > Daniel Morgan
> >

Find the init.ora file. It likely has a name like initORACLE.ora and is located in a directory such as:

c:\oracle\ora81\database

Make a backup copy of the file before making any changes in case you mess things up.

Edit the file and make the appropriate changes. Save the file
Restart your computer (unless you know how to restart Oracle without restarting your computer)

Daniel Morgan Received on Mon Jun 17 2002 - 15:39:49 CDT