Re: ORA-27101: shared memory realm does not exist

Frank van Bortel wrote:
> Mathijs schreef:
>
> > 01 nov 2006, (Charles Hooper):
> >
> > > Check the initialization file, check the alert log.
> >
>
> I suspect this has something to do with it:
>
> > Mon Oct 30 11:35:58 2006
> > Memory Notification: Library Cache Object loaded into SGA
> > Heap size 2208K exceeds notification threshold (2048K)
> > KGL object name :XDB.XDbD/PLZ01TcHgNAgAIIegtw==
>
> However, I would not know where to start resolving this...
> Someone else, perhaps?
>
> Any more messages after this line?

I believe that "Heap size 2208K exceeds notification threshold (2048K)" just indicates that a large object is being read into the SGA. Each object loaded into the SGA requires a continuous range of memory. Loading and unloading of large objects into the SGA can cause lot of little available memory areas, that may be too small for a slightly larger object to use, thus the instance may reach the SGA_MAX size quicker than expected. This is just a polite warning that a large (2.2MB) object is being loaded.

I almost tripped over that warning too.

Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc. Received on Wed Nov 01 2006 - 10:49:34 CST