Oracle Library Cache Object loaded into SGA

Alert warning error found in the test database today

Memory Notification: Library Cache Object loaded into SGA
Heap size 2919 K exceeds notification threshold (2048 K)
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,
E. stat_name,

Tue May 6 11:12:12 2014
Memory Notification: Library Cache Object loaded into SGA
Heap size 2757 K exceeds notification threshold (2048 K)
Details in trace file/u01/app/Oracle/admin/amidb/udump/amidb_or

Later, I checked on the Internet that the parameter _ kgl_large_heap_warning_threshold was originally implied in the Oracle 10.2.0.1 database. The default value of this parameter is 2 M, which controls the size of objects loaded into the memory, when the loaded object is larger than 2 MB, a prompt is displayed in the alert warning file. The default value of 2 Mb is relatively small. Therefore, this error message may be easily reported in 10.2.0.1. The default value of this parameter is adjusted to 50 MB in version 10.2.0.2.

Alter system set "_ kgl_large_heap_warning_threshold" = 52428800 scope = spfile;

System altered.