Re: Calculating Physical memory for Oracle Sessions

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_at_evdbt.com> 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_at_evdbt.com
> 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
>
>
>

--
http://www.freelists.org/webpage/oracle-l