Where are the other memory users? If I shutdown both OracleDB and OracleApps (EBS), The memory held is still 2GB and the ipcs -a commnad does not show any memory holders. Why is the memory being locked-in?
Shared memory segment is always allocated with the same size as you maximum sga, it does not mean that all memory is used.
SGA is not pinned into the memory at the startup unless you use sga_lock=true and (i am not 100% sure about that) hugemem pages.
As far as mistery regarding where is the memory , I have spent hours with the oracle support, many tar's later I have realized that nobody knows much about it besides the fact that top and free do not report memory allocation the same way as oracle is using it. It is due to kernel internals, you can really get into it if you want to, you have to account for cache, buffers, dirty pages, etc,
I use free command , i look at the free memory +- buffers / cache. After database stopped, cached bufferes are not being released immediately, it will be cached until memory is needed.
Pages allocate to cache should be given back to the application if memory is needed.
Last edited by BV1963; 07-07-2008 at 04:12 PM.
One, who thinks that the other one who thinks that know and does not know, does not know either!