Home » RDBMS Server » Performance Tuning » Oracle Memory Leakage (9.2.0.5.0, Sun OS 5.9)
Oracle Memory Leakage [message #287805] Thu, 13 December 2007 10:07 Go to next message
kudur_kv
Messages: 75
Registered: February 2005
Member
Hi,

One of the production servers (9.2.0.5.0) is supposedly suffering from a memory leakage issue. This was identified by the DBAs of the company who provide the application. They have also suggested that the database be upgraded to 9.2.0.8.

The question is, what are the symptoms that one should look for when there is actually a memory leakeage? And is there any chance of salvaging any performance improvements by bouncing the DB daily?

The server hosts 3 other databases as well. But the larget database is about 100+ GB in size is the one that we are having problems with.

Thank you
K V
Re: Oracle Memory Leakage [message #287808 is a reply to message #287805] Thu, 13 December 2007 10:19 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:

what are the symptoms that one should look for when there is actually a memory leakeage?

Abort, code dump, message in alert.log

Quote:

And is there any chance of salvaging any performance improvements by bouncing the DB daily?

No, this is the opposite.

Regards
Michel
Re: Oracle Memory Leakage [message #287890 is a reply to message #287808] Fri, 14 December 2007 00:01 Go to previous messageGo to next message
kudur_kv
Messages: 75
Registered: February 2005
Member
One of the major issues that we were having a few weeks ago was that the DB used to go down with shutdown abort. This was specifically more during the time when the RMAN backups were running on the server along with the batch jobs that were running on the database.
The batch jobs seem to doing quite a bit of write operations on the database as 95% of the archive logs generated in the day.

You are right about the shutdown abort. That keeps happening quite frequently. The clients are mad about it, but dont seem to be doing anything to upgrade the database to 9.2.0.8?

Are there any short term solutions to fix the Abort shutdowns or minimize the memory leakage?

Thank you.
Re: Oracle Memory Leakage [message #287903 is a reply to message #287890] Fri, 14 December 2007 00:40 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Not with the information you gave.
I suggest you to contact Oracle support.

Regards
Michel
Re: Oracle Memory Leakage [message #288117 is a reply to message #287805] Fri, 14 December 2007 22:53 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

>The server hosts 3 other databases as well.
Also recommended if you maintain 1:1 ratio.(OS server for one Oracle Server).
Previous Topic: This query make much recursive call
Next Topic: STATSPACK
Goto Forum:
  


Current Time: Sat Dec 03 13:50:13 CST 2016

Total time taken to generate the page: 0.07811 seconds