Tim, Thanks a lot. That was good explanation. Now, all the numbers add up.
Thanks again Sonia P. --- "Johnston, Tim" <[EMAIL PROTECTED]> wrote: > 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). __________________________________________________ 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).
