| What is the error? [message #289681] |
Tue, 25 December 2007 05:25  |
trantuananh24hg
Messages: 744
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  |
 |
Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...
|
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 #289725 is a reply to message #289687] |
Tue, 25 December 2007 22:23 |
trantuananh24hg
Messages: 744
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!
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
