Dedicated connections and Memory usage

2002-06-26 Thread Loughmiller, Greg
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 ded

RE: Dedicated connections and Memory usage

2002-06-26 Thread Vikas Khanna
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.. W

Re: Dedicated connections and Memory usage

2002-06-26 Thread Rachel Carmichael
SGA is shared memory so it will show up looking as though the individual connections are as large as the SGA (or larger, to include the PGA). In reality they are sharing a large chunk of the memory ipcs -m will show you the memory segment allocation for the SGA, subtract that from the memory each