oracle library cache object loaded into sga
今天在测试数据库发现alert出现警告错误
memory notification: library cache object loaded into sga
heap size 2919k 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,
tue may  6 11:12:12 2014
memory notification: library cache object loaded into sga
heap size 2757k exceeds notification threshold (2048k)
details in trace file /u01/app/oracle/admin/amidb/udump/amidb_or
后来在网上查了一下原来是在oracle 10.2.0.1版本数据库中隐含参数_kgl_large_heap_warning_threshold默认值是2m，该参数控制加载到内存中对象的大小，当加载的对象大于2m时，就会在alert警告文件中进行提示。2m的默认大小相对太小，因此在10.2.0.1版本中可能很容易遇到这个报错信息。该参数默认值在10.2.0.2版本中进行了调整，，调整到了50m。
alter system set _kgl_large_heap_warning_threshold=52428800 scope=spfile;
system altered.
本文永久更新链接地址：