Discussion :

[nabou]

les utilisateur n'arrive pas à se connecter à la base via keur application

j'ai dans la trace ce message

quelq'un peut il me dire si je dois augmnter la taille de la sga cible

Memory Notification: Library Cache Object loaded into SGA
Heap size 2179K exceeds notification threshold (2048K)

merci par avance

[orafrance]

Voila la réponse du support :

Subject: Memory Notification: Library Cache Object Loaded Into Sga
Doc ID: Note:330239.1 Type: PROBLEM
Last Revision Date: 05-JUN-2006 Status: PUBLISHED

In this Document
Symptoms
Changes
Cause
Solution
References

Applies to:
Oracle Server - Enterprise Edition - Version:
This problem can occur on any platform.
.
Symptoms

The following messages are reported in alert.log after 10g Release 2 is installed.

Memory Notification: Library Cache Object loaded into SGA
Heap size 2294K exceeds notification threshold (2048K)
Changes

Installed / Upgraded to 10g Release 2
Cause

These are warning messages that should not cause the program
responsible for these errors to fail.
They appear as a result of new event messaging mechanism
and memory manager in 10g Release 2. The meaning is that the
process is just spending a lot of time in finding free memory
extents during an allocate as the memory may be heavily fragmented.
Real memory messages should be ORA-403x when a real memory allocation problem
occurs.
Solution

In 10g we have a new undocumented parameter that sets the KGL heap size
warning threshold. This parameter was not present in 10gR1.
Warnings are written if heap size exceeds this threshold.

Set _kgl_large_heap_warning_threshold to a reasonable high value or zero
to prevent these warning messages. Value needs to be set in bytes.

If you want to set this to 8192 (8192 * 1024) and are using an spfile:

(logged in as "/ as sysdba")

SQL> alter system set "_kgl_large_heap_warning_threshold"=8388608 scope=spfile ;

SQL> shutdown immediate SQL> startup

SQL> show parameter _kgl_large_heap_warning_threshold
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
_kgl_large_heap_warning_threshold integer 8388608

If using an "old-style" init parameter,

Edit the init parameter file and add

_kgl_large_heap_warning_threshold=8388608



In 10.2.0.2, the threshold is increased to 50MB after regression tests, so this should be a reasonable and recommended value.

[nabou]

bonjour,

j'ai posé le problème il ya quelque jours et j'ai eu la réponse mais après avoir fais les modifiactions dans le init.ora , j'ai toujours le meme message d'erreur

Memory Notification: Library Cache Object loaded into SGA
Heap size 3063K exceeds notification threshold (2048K)

j'ai mis le parametre

_kgl_large_heap_warning_threshold=(2048*1024)=2097152

ma question est la suivante :

j'ai pris la valeur 2048 en me basant sur la valeur de db_block_size est ce j'ai bien fais ou je peux augmenter la valeur à 8192 ?


merci d'avance