SUMMARY: Oracle reserve memory question

From: Stephanie C <stepchung_at_gmail.com>
Date: Thu Jan 17 2008 - 12:00:55 EST
Thank you for all responses. Most of you were pointing to DBA. I have the
proofs from all of you to deal with the DBA guy. I think this has to do with
the way DBA setup/configure/install of Oracle db. Thanks again.
Steph.
---------- Forwarded message ----------
From: Stephanie C <stepchung@gmail.com>
Date: Jan 16, 2008 3:44 PM
Subject: Oracle reserve memory question
To: Sun Managers <sunmanagers@sunmanagers.org>


We are running oracle db 9i on Sun v245 solaris 10. This server is really
having performance issue. We are trying to work with DBA, Oracle consultant
to figure out what is the cause? Until now, they and we don't know what is
the problem. According to DBA, all the kernel parameters are met for oracle
db. What I can see here is each oracle process is using too much memory.

#prstat -J
   PID USERNAME  SIZE   RSS STATE  PRI NICE      TIME  CPU
PROCESS/NLWP
 10430 oracle          665M  635M sleep   49    0   0:01:56 0.7% oracle/1
 10420 oracle          665M  635M sleep   41    0   0:01:53 0.7% oracle/1
 10438 oracle          665M  635M sleep   48    0   0:01:57 0.7% oracle/1
  5718  oracle          665M  635M sleep   56    0   0:17:57 0.7% oracle/1
 10436 oracle          665M  635M sleep   53    0   0:01:55 0.7% oracle/1
.....

Why the oracle processes are using too much memory and reserve memory? Is
there a way to set the reserve memory for oracle processes to use less
memory. Thanks for your help.

Stephanie.
_______________________________________________
sunmanagers mailing list
sunmanagers@sunmanagers.org
http://www.sunmanagers.org/mailman/listinfo/sunmanagers
Received on Thu Jan 17 12:01:15 2008

This archive was generated by hypermail 2.1.8 : Thu Mar 03 2016 - 06:44:08 EST