The problem is that top reports the ENTIRE shared memory segment in EVERY
process... For example... If your shared memory segment is 300M and top
reports memory usage of 320-340M per process... You are in reality using
about 20-40M of private memory in each process and 300M of shared memory...
But, shared memory is only allocated once...
i.e.
Shared memory segment of 300M
top reports shared memory private usage by process
process1 320M 300M 20M
process2 330M 300M 30M
process3 320M 300M 20M
process4 340M 300M 40M
So... Your total memory usage is...
20M + 30M + 20M + 40M + 300M = 410M
Not...
320M + 330M + 320M + 340M = 1310M
Does that help explain it?
Tim
-----Original Message-----
Sent: Wednesday, January 30, 2002 4:45 PM
To: Multiple recipients of list ORACLE-L
I am sorry I did not specify the os. We are using
solaris 2.8 and We are using top utility to look at
the oracle user process. As far as I know, ipcs -ma
will give me the size of the entire memory segment. I
am trying to find the values for each user
connection..
Thanks
Sonia P.
Unix I assume? How are you determining the memory
usage? Many unix
utilities can be misleading (i.e top) and report the
shared memory segment
in each process... Check ipcs -ma to see the size of
the shared memory
segment...
HTH
Tim
__________________________________________________
Do You Yahoo!?
Great stuff seeking new owners in Yahoo! Auctions!
http://auctions.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: sonia pajerowski
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Johnston, Tim
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
