RE: Oracle shadow process

From: Johnston, Tim <TJohnston_at_quallaby.com>
Date: Wed, 30 Jan 2002 14:47:29 -0800
Message-ID: <F001.004012D1.20020130144023@fatcity.com>

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: spajerowski_at_yahoo.com

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: ListGuru_at_fatcity.com (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: TJohnston_at_quallaby.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------