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
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: 2454
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: 63806
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: Problem in understanding the autotrace output exectution plan and statistics
Next Topic: Update statement query tuning
Goto Forum:
  


Current Time: Wed Sep 28 04:01:05 CDT 2016

Total time taken to generate the page: 0.08137 seconds