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

From: Allaoua BOUABDALLAH <root_at_agrfrlinux1.concept-agresso.com>
Date: Wed, 29 Dec 1999 17:08:32 GMT
Message-ID: <aemtoew6.fsf@agrfrlinux1.concept-agresso.com>

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 Wed Dec 29 1999 - 11:08:32 CST