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

About these ads

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