Heap size exceeds notification threshold ?

Posted: August 8, 2011 in Oracle Troubleshooting
Tags: , , ,

One of my clients reported to me below warning in Alertlog

Mon Aug  8 10:48:01 2011
Memory Notification: Library Cache Object loaded into SGA
Heap size 2935K exceeds notification threshold (2048K)
KGL object name :select
     service_name, uio_waits, uio_time, con_waits, con_time,
     adm_waits, adm_time, net_waits, net_time
   from
    (select
       stat1.service_name service_name, db_time, uio_waits, uio_time,
       con_waits, con_time, adm_waits, adm_time, net_waits, net_time
     from
      (select s1.service_name,
              sum(decode(s1.stat_name, ‘DB time’, s1.diff, 0)) db_time
       from
         (select e.service_name     service_name,
                 e.stat_name        stat_name,

So what is this about?

The solution was well documented in Memory Notification: Library Cache Object Loaded Into Sga [ID 330239.1]

The client is using 10.2.0.1 which the threshold limit is 2MB, in 10.2.0.2 the limit was increased to 50MB which should be enough in most cases

Happy debugging

Cheers

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s