Re: Calculating Physical memory for Oracle Sessions
- From: "Anand Rao" <panandrao@xxxxxxxxx>
- To: tim@xxxxxxxxx
- Date: Thu, 30 Nov 2006 10:28:23 +0530
Tim,
There are lots of good AIX goodies for processes :)
From AIX 5.3, procmon is a great to use that gives you a more detailed and
elaborate "pmap" like service.
procmon is a GUI tool (but surprising useful unlike many others).
It has the following options to perform detailed process analysis,
procfiles
proctree
procsig
procstack
procrun
procmap
procflags
proccred
procldd
you need to select a process from the main screen and then run one of these
commands on that, all using the GUI.
Of course, pmap is much easier to use as it is a single command-line tool.
regards
anand
On 30/11/06, Tim Gorman <tim@xxxxxxxxx> wrote:
Anurag,
I have this shell script named "oramem.sh" posted online at
http://www.EvDBT.com/tools.htm. It was originally written for Solaris
using the excellent "pmap" utility. It can work with Linux if the SYSSTAT
rpms are installed, which include "pmap". I have an alternate version for
HPUX that uses some custom-built "C" programs. I don't have a version for
AIX at all, as I haven't found anything similar to "pmap" on AIX.
Hope this helps...
--
Tim Gorman
consultant - Evergreen Database Technologies, Inc.
website = http://www.evdbt.com
email = tim@xxxxxxxxx
mobile = +1-303-885-4526
fax = +1-303-484-3608
Anurag Verma wrote:
Hi All,
My 9.2.0.7 database has an sga size of 1.3 GB and the RAM size is 4096 MB.
We were facing a problem of memory contention yesterday due to the
increased number of sessions/connections to the database.
96% of the Physical memory and 94-95% of virtual memory was used, when
checked the processes in the IBM AIX server.
So when the number of sessions increased, listener stopped receiving newer
connections.
The ever increasing number of sessions were taking up the memory.
Latch free contention was there and found library cache latch stats were
showing large number of sleeps.
If we need to increase shared pool, memory was not available.
One option we are planning is to increase the physical memory.
So my question is how do we determine the size of the memory used for
Oracle sessions.
Say for adding another 100 sessions, how much memory will it take, so that
it will help us in adding more RAM in to the server.
Thanks for your thoughts on this.
Anurag
Other related posts:
