Re: Weird messages in the alert.log file

  • From: "Niall Litchfield" <niall.litchfield@xxxxxxxxx>
  • To: htmldeveloper@xxxxxxxxx
  • Date: Tue, 24 Jun 2008 08:43:49 +0100

It's a warning. As of 10gR2 Oracle will warn if objects larger than a value
specified by the hidden parameter _kgl_large_heap_warning_threshold are
loaded into the shared pool - presumably to warn of possible fragmentation
issues for the shared pool and thus ORA-4331 errors later. You can change
the parameter, but as it's a hidden parameter you may wish to get supports
blessing first.






-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

Other related posts: