Memory Notification: Library Cache Object loaded into SGA问题
精选 转载问题:alert_SID.log出现
Memory Notification: Library Cache Object loaded into SGA
Heap size 2289K exceeds notification threshold (2048K)
Oracle10g中,在load较大的对象进library cache中时,会记录以上警告。在版本10.2.0.1中,这个定义大对象的阈值是2M,这是有隐含参数 _kgl_large_heap_warning_threshold指定的,如果系统中需要load很多大对象,又不想在alert中看到太多这类的警 告信息,可以修改该参数:
SQL> alter system set "_kgl_large_heap_warning_threshold"=8388608 scope=spfile;
参数值以字节为单位,设置完后需要重启实例才能生效。
从10.2.0.2起,这个参数的默认值被修改为50M.
下面是oracle上的metalink信息:
Memory Notification: Library Cache Object Loaded Into Sga
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
NOTE: The default threshold in 10.2.0.1 is 2M. So these messages could show up frequently in some application environments.
In 10.2.0.2, the threshold was increased to 50MB after regression tests, so this should be a reasonable and recommended value. If you continue to see the these warning messages in the alert log after applying 10.2.0.2 or higher, please contact Oracle Support Services for further investigation of any possible shared pool problems.
提问和评论都可以,用心的回复会被更多人看到
评论
发布评论
相关文章
-
ES6的Object.fromEntries()和Object.hasOwn()
Object.fromEntries()方法是Object.entries()的逆操作,用于将一个键值对数组转为对象。
键值对 Object.hasOwn() Object.fromEntries -
LangChain之内存记忆 ( Memory )
大多数LLM应用都具有对话功能,如聊天机器人,记住先前的交互非常关键。对话的重要一环是能够引用之前提及的信息,这些信息需要进行存储,因此将这种存储过去交互信息的能力称为记忆 ( Memory )。
初始化 python Memory LLM LangChain -
oracle alert出现Memory Notification: Library Cache Object loaded into SGA
1、今天检查oracle数据库时,发现alert出现这种情况Memory Notification: Library Cache Object loaded into SGAHeap size 11226K exceeds notification threshold (10240K)KGL object name :select fund0_.FUND_ID as FUND1_39_0_
oracle Object Memory into loaded -
Memory Notification: Library Cache Object Loaded Into Sga (文档 ID 330239.1)
内容来自:https://support.oracle.com/ Applies to: Oracle Database - Enterprise Edition - Version 10.2.0.1 and later Information in this document applies to any platform. Oracle Server Enterprise Editio
document Object Memory blank applies