Home » RDBMS Server » Server Administration » What is the error?
What is the error? [message #289681] Tue, 25 December 2007 05:25 Go to next message
trantuananh24hg
Messages: 668
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
Hi all!

Today, I have encountered an error

Quote:


Memory Notification: Library Cache Object loaded into SGA
Heap size 2297K exceeds notification threshold (2048K)
KGL object name :SELECT SYNNAM, DBMS_JAVA.LONGNAME(SYNNAM), DBMS_JAVA.LONGNAME(SYNTAB), TABOWN, TABNODE, PUBLIC$, SYNOWN, SYNOWNID, TABOWNID, SYNOBJNO FROM SYS.EXU9PTS WHERE SYNOBJNO IN ( SELECT SYNOBJNO FROM SYS.EXU9TYPTU WHERE TABOBJNO = :1 ) ORDER BY SYNTIME
Tue Dec 25 09:46:05 2007javascript://
javascript://
Process P061 died, see its trace file
Tue Dec 25 10:17:32 2007
Process P062 died, see its trace file
Tue Dec 25 10:17:34 2007
Process P063 died, see its trace file
Tue Dec 25 14:28:52 2007
Process P042 died, see its trace file



I did not see the trace file because the alert log file did not navigated.
What's this error? What or any action caused it?

SGA_TARGET in the Database is
SQL> show parameter sga

NAME                                 TYPE
------------------------------------ --------------------------------
VALUE
------------------------------
lock_sga                             boolean
FALSE
pre_page_sga                         boolean
FALSE
sga_max_size                         big integer
6096M
sga_target                           big integer
6096M


OS: Solaris 10
DB: 10.2.0

Thank so much!
Re: What is the error? [message #289686 is a reply to message #289681] Tue, 25 December 2007 06:23 Go to previous messageGo to next message
Michel Cadot
Messages: 64122
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:

Memory Notification: Library Cache Object loaded into SGA
Heap size 2297K exceeds notification threshold (2048K)
KGL object name :SELECT SYNNAM, DBMS_JAVA.LONGNAME(SYNNAM), DBMS_JAVA.LONGNAME(SYNTAB), TABOWN, TABNODE, PUBLIC$, SYNOWN, SYNOWNID, TABOWNID, SYNOBJNO FROM SYS.EXU9PTS WHERE SYNOBJNO IN ( SELECT SYNOBJNO FROM SYS.EXU9TYPTU WHERE TABOBJNO = :1 ) ORDER BY SYNTIME


This is not an error it is just an informative indicating that a big object has been loaded in SGA and it has no relation with the subsequent messages.
For these ones you have to have a look at trace files as stated by the messages.

By the way, when you remove some part of a file, please show it with, for instance a line of dots. This will prevent from leading us to the same wrong conclusion as you did.

Regards
Michel
Re: What is the error? [message #289687 is a reply to message #289681] Tue, 25 December 2007 06:24 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

It is warning message.
check it here.
http://sabdarsyed.blogspot.com/2007/03/warning-memory-notification-library.html

and also contact oracle support means submit your alert<sid>.log and trace to oracle and wait for their suggestion.
Re: What is the error? [message #289725 is a reply to message #289687] Tue, 25 December 2007 22:23 Go to previous message
trantuananh24hg
Messages: 668
Registered: January 2007
Location: Ha Noi, Viet Nam
Senior Member
Thank you, Michel and Mohammad!

I found this warnning message in Metalink, then I altered this hidden parameter in Test DB before applying in Production.

It's seem like to miss this warning in alert log file.

Thank again!
Previous Topic: backup concept(user managed)
Next Topic: How Oracle Read blocks
Goto Forum:
  


Current Time: Wed Dec 07 05:03:27 CST 2016

Total time taken to generate the page: 0.06977 seconds