Oracle-L: RE: Dedicated connections and Memory usage

From: Vikas Khanna <vkhanna_at_quark.co.in>
Date: Wed, 26 Jun 2002 04:58:21 -0800
Message-ID: <F001.004884BF.20020626045821@fatcity.com>

Use need to use pmap feature of Unix in order to see the real RAM associated with the processes.

Vikas Khanna
Oracle - DBA

-----Original Message-----
Sent: Wednesday, June 26, 2002 5:45 PM
To: Multiple recipients of list ORACLE-L

Need a little assistance on some "concepts", so to speak..

When looking at the processes(dedicated connections) of an 816 database on a UNIX environment-the memory used for each process appears to be the same as the SGA.
It's been awhile since I had to "dig" into this, but I thought that the dedicated connections had their own PGA(real memory of the machine). So is it coincidence that the dedicated connections (all 180 of them) are using the same amount of memory as the SGA??

What am I missing here???

TIA Greg Loughmiller
Sr Manager - Enterprise Data Architecture gloughmiller (IPS)
678.893.3217 (office)

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Loughmiller, Greg
INET: Greg.Loughmiller_at_cingular.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: Vikas Khanna
INET: vkhanna_at_quark.co.in

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