Home » RDBMS Server » Performance Tuning » Memory Notification: Library Cache Object loaded into SGA (oracle 10g)
Memory Notification: Library Cache Object loaded into SGA [message #436088] Mon, 21 December 2009 07:12 Go to next message
gir_sat
Messages: 64
Registered: October 2008
Location: Mumbai
Member
Hi,

I am getting message in my database alert log file as:

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

Kindly let me know what should i approach for it.

Thanks

Report message to a moderator

Re: Memory Notification: Library Cache Object loaded into SGA [message #436089 is a reply to message #436088] Mon, 21 December 2009 07:19 Go to previous messageGo to next message
ramoradba
Messages: 2457
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
see this blog As i din`t get this error before
And always search before posting....
sriram Smile

[Updated on: Mon, 21 December 2009 07:22]

Report message to a moderator

Re: Memory Notification: Library Cache Object loaded into SGA [message #436094 is a reply to message #436088] Mon, 21 December 2009 08:02 Go to previous message
Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Just a warning you can ignore it or set "_kgl_large_heap_warning_threshold" to a greater value than the default one (2048K) to prevent from it to happen.
It is ona of the rare underscode parameters you can set without any issue.
It was introduced just to warn that a big object was loaded into memory. If it is normal for your case, just ignore it.

Regards
Michel

Report message to a moderator

Previous Topic: Problem in understanding the autotrace output exectution plan and statistics
Next Topic: Update statement query tuning
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Feb 18 23:28:01 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.