Home » RDBMS Server » Server Administration » Memory Notification (10g)
Memory Notification [message #427683] Sat, 24 October 2009 01:20 Go to next message
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
Re: Memory Notification [message #427686 is a reply to message #427683] Sat, 24 October 2009 01:24 Go to previous messageGo to next message
Michel Cadot
Messages: 63808
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Just a notification, you can ignore it.

Regards
Michel
Re: Memory Notification [message #427688 is a reply to message #427686] Sat, 24 October 2009 01:27 Go to previous messageGo to next message
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
Re: Memory Notification [message #427690 is a reply to message #427683] Sat, 24 October 2009 01:31 Go to previous messageGo to next message
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
Re: Memory Notification [message #427691 is a reply to message #427690] Sat, 24 October 2009 01:39 Go to previous messageGo to next message
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
Re: Memory Notification [message #427692 is a reply to message #427683] Sat, 24 October 2009 01:43 Go to previous messageGo to next message
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
Re: Memory Notification [message #427693 is a reply to message #427688] Sat, 24 October 2009 01:50 Go to previous messageGo to next message
Michel Cadot
Messages: 63808
Registered: March 2007
Location: Nanterre, France, http://...
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

Re: Memory Notification [message #427694 is a reply to message #427693] Sat, 24 October 2009 01:55 Go to previous messageGo to next message
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
Re: Memory Notification [message #427696 is a reply to message #427694] Sat, 24 October 2009 02:14 Go to previous message
BlackSwan
Messages: 24912
Registered: January 2009
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.
Previous Topic: Transparent Data Encryption
Next Topic: Problem in using Resource Manager
Goto Forum:
  


Current Time: Wed Sep 28 21:12:08 CDT 2016

Total time taken to generate the page: 0.05866 seconds