OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Memory Notification (10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Memory Notification [message #427683]

Sat, 24 October 2009 01:20

gir_sat
Messages: 64
Registered: October 2008
Location: Mumbai

Member

Hi,

I am getting this error in my database alert.

Memory Notification: Library Cache Object loaded into SGA
Heap size 2108K exceeds notification threshold (2048K)

Kindly help as early as possible.

Thanks

Report message to a moderator

Re: Memory Notification [message #427686 is a reply to message #427683]

Sat, 24 October 2009 01:24

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Just a notification, you can ignore it.

Regards
Michel

Report message to a moderator

Re: Memory Notification [message #427688 is a reply to message #427686]

Sat, 24 October 2009 01:27

gir_sat
Messages: 64
Registered: October 2008
Location: Mumbai

Member

But,

now db performance is very poor.

Even even i amseeing sar report(os is linux),
it is giving 25% idle and %user as 25 and %system as 25.

thanks again

Report message to a moderator

Re: Memory Notification [message #427690 is a reply to message #427683]

Sat, 24 October 2009 01:31

balakrishnay
Messages: 54
Registered: September 2009
Location: Pune

Member

Hi,

Look at the session waits and start looking at which one is causing the issue.

set lines 120
set pages 1000
col event for a30
select sid, event, p1, p2, p3, p1raw from v$session_wait
where event not like '%messag%' and event not in ('pipe get','PL/SQL lock timer','Streams AQ: qmn slave idle wait','Streams A
Q: waiting for time management or cleanup tasks','Streams AQ: qmn coordinator idle wait')
and (wait_time=0 or state='WAITING')
order by 2
/

Regards

Bala

Report message to a moderator

Re: Memory Notification [message #427691 is a reply to message #427690]

Sat, 24 October 2009 01:39

gir_sat
Messages: 64
Registered: October 2008
Location: Mumbai

Member

Hi
this is the output.
Kindly tell me how to appraoch for the issue.

SID EVENT P1 P2 P3 P1RAW
---------- ------------------------------ ---------- ---------- ---------- --------
648 Backup: sbtbackup 0 0 0 00
620 RMAN backup & recovery I/O 1 256 4294967295 00000001
638 Streams AQ: waiting for time m 0 0 0 00
anagement or cleanup tasks

665 pmon timer 300 0 0 0000012C
659 smon timer 300 0 0 0000012C

Report message to a moderator

Re: Memory Notification [message #427692 is a reply to message #427683]

Sat, 24 October 2009 01:43

balakrishnay
Messages: 54
Registered: September 2009
Location: Pune

Member

Hi,

By looking at the waits .. RMAN backup is going on in your server .. rest all are idle wait events.

Regards

Bala

Report message to a moderator

Re: Memory Notification [message #427693 is a reply to message #427688]

Sat, 24 October 2009 01:50

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

gir_sat wrote on Sat, 24 October 2009 08:27

But,

now db performance is very poor.

Even even i amseeing sar report(os is linux),
it is giving 25% idle and %user as 25 and %system as 25.

thanks again

No relation with the message.
First check your application, then your IO subsystem (once you have optimized your application not before).

Regards
Michel

Report message to a moderator

Re: Memory Notification [message #427694 is a reply to message #427693]

Sat, 24 October 2009 01:55

gir_sat
Messages: 64
Registered: October 2008
Location: Mumbai

Member

Thanks all of you,

Can anyone tell me how to analyze the statspack report for performance tunning problem.

Thanks once again

Report message to a moderator

Re: Memory Notification [message #427696 is a reply to message #427694]

Sat, 24 October 2009 02:14

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Can anyone tell me how to analyze the statspack report for performance tunning problem.

Just because something appears in any TOP N list,
does not means it is broken & needs to be fixed.

In a Top 5 list FIVE will alway be listed whether or not any problem exists.

Report message to a moderator

Previous Topic:	Transparent Data Encryption
Next Topic:	Problem in using Resource Manager

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 11:25:54 CST 2024