Friday, June 15, 2012

_kgl_large_heap_warning_threshold -- oracle 10.2 hidden parameter


Today in my environment i faced the below error message

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

for that i found the solution

In 10.2.0.2, the threshold was increased to 50MB after regression tests, so this should be a reasonable and recommended value.

So, you may try to increase the parameter  _kgl_large_heap_warning_threshold= 52428800

SQL> alter system set "_kgl_large_heap_warning_threshold"=52428800 scope=spfile ;
SQL> shutdown immediate
SQL> startup

Strongly recommend you to upgrade the database to the latest patchset which is 10.2.0.5,
where you can avoid such problems.

No comments:

Post a Comment

Friday, June 15, 2012

_kgl_large_heap_warning_threshold -- oracle 10.2 hidden parameter


Today in my environment i faced the below error message

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

for that i found the solution

In 10.2.0.2, the threshold was increased to 50MB after regression tests, so this should be a reasonable and recommended value.

So, you may try to increase the parameter  _kgl_large_heap_warning_threshold= 52428800

SQL> alter system set "_kgl_large_heap_warning_threshold"=52428800 scope=spfile ;
SQL> shutdown immediate
SQL> startup

Strongly recommend you to upgrade the database to the latest patchset which is 10.2.0.5,
where you can avoid such problems.

No comments:

Post a Comment

My Blog List