Home » RDBMS Server » Server Administration » Database is too slow
Database is too slow [message #198872] Wed, 18 October 2006 22:17 Go to next message
sreehari
Messages: 101
Registered: May 2006
Senior Member
Hi all

all of a sudden my database became very slow, when i checked in alert log, i found some information.

Thu Oct 19 01:30:13 2006
Memory Notification: Library Cache Object loaded into SGA
Heap size 2150K exceeds notification threshold (2048K)
KGL object name :XDB.XDbD/PLZ01TcHgNAgAIIegtw==

Thu Oct 19 01:30:15 2006
Memory Notification: Library Cache Object loaded into SGA
Heap size 2387K exceeds notification threshold (2048K)
Details in trace file d:\oracle\product\10.2.0\admin\poeticdb\udump\poeticdb_ora_2272.trc
KGL object name :XDB.XDZynXpO5DTv2jNMI2jLTZZA==

what does is it mean? what should i do to improve the performance?

Thanks
Re: Database is too slow [message #198876 is a reply to message #198872] Wed, 18 October 2006 22:41 Go to previous message
fuyuncat
Messages: 2
Registered: October 2006
Junior Member

hi,

U can try to expand an undocumented parameter _kgl_large_heap_warning_threshold, which limit kgl heap size (default is 2048K).


regards
Previous Topic: agent fails to start on oracle 9206
Next Topic: nls_date_format problem
Goto Forum:
  


Current Time: Sun Dec 04 00:13:02 CST 2016

Total time taken to generate the page: 0.10868 seconds