Re: SGA size and ipcs information differ on Oracle/Linux

If the JSERVER is not used, you can save 19MB of memory by setting the java_pool_size to its minimum value of 1 million bytes, i.e. java_pool_size = 1000000.

CT

Allaoua BOUABDALLAH wrote:

> You are right.
> The java_pool_size default to 20Mb.
> 5Mb + 20Mb give me what ipcs reported me.
>
> Thank's.
>
> PS: this is a simple test database.
>
> "Michael Ju. Tokarev" <mjt_at_tls.msk.ru> writes:
>
> > root wrote:
> > >
> > > We create an Oracle database with approximatively 5Mb of SGA.
> > > "Show sga" report us 5Mb but all others tools like gtop, top
> > > and mainly ipcs report us that we have 25Mb of shared memory.
> > >
> > > Does anyone encountoured this problem on Linux ?
> > >
> > > Thank's
> > >
> >
> > Top etc report total memory usage that is sum of data and code
> > (e.g. executables). And Oracle's memory consists not only from
> > sga. See shared_pool_size, large_pool_size, java_pool_size,
> > db_block_buffers, log_buffers etc etc, and note that "show sga"
> > command lists only some of them.
> >
> > P.S. 5Mb is very small, at least for 8.x...

Received on Thu Dec 30 1999 - 06:41:47 CST