Version imprimable
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
Voila la réponse du support :
Citation:
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.
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