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.
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