I found this message in my oracle database alert log file. my database version is 10.2.0.1 .
clue:-
This is for an undocumented parameters value. which parameter is
"_kgl_large_heap_warning_threshold"
This is new in 10g release 2 and in 10.2.0.1 default threshold value is 2Mb.
and in 10.2.0.2 and above default threshold value is 50Mb.
so, for avoiding this type of warning message from alert log file you have to configure in parameter
"_kgl_large_heap_warning_threshold" to a reasonable high value or zero . Value needs to be set in bytes.
or upgrate the Database version.
Halim is a Sr. Database Engineer/Data Architect (in Atlanta, USA) who is an Oracle certified (OCP) DBA, (OCP) Developer, Certified Cloud Architect Professional as well as OCI Autonomous DB specialist with extensive expertise in Database design, configuration, tuning, capacity planning, RAC, DG, Scripting, Python, PL/SQL etc. He achieved 16th position in worldwide first-ever PL/SQL Challenge cup playoff- http://plsql-challenge.blogspot.com/2010/07/winners-of-first-plsql-challenge.html
Sunday, November 13, 2011
Memory Notification: Library Cache Object loaded into SGA Heap size K exceeds notification threshold (2048K)
Labels:
memory
Subscribe to:
Post Comments (Atom)
My Blog List
-
-
-
-
4096 Columns3 weeks ago
-
-
-
-
-
-
Oracle Cloud & Third party tools4 years ago
-
-
-
Moving Sideways8 years ago
-
Upcoming Events...10 years ago
-
No comments:
Post a Comment