| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: ORA-27101: shared memory realm does not exist
Frank van Bortel wrote:
> Charles Hooper schreef:
> > 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.
> >
> Hm - it has nothing to do with limits imposed on XE, then?
>
Correction:
"continuous" should read "contiguous"
"cause lot of little available memory areas" should read "cause a large
number of small non-contiguous memory areas"
http://download-east.oracle.com/oowsf2005/003wp.pdf (bottom of page 10, top of page 11)
This is a new feature of 10g R2. I have seen the same warning in 10.2.0.2 Standard Edition. There is a way to disable the warning, but I can't recall the method right now (might be _kgl_large_heap_warning_threshold).
Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc.
Received on Wed Nov 01 2006 - 13:37:57 CST
 |
 |