Re: memory process use is 10M is that normal?mlml

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Wed, 21 Jul 1999 21:21:18 +0800
Message-ID: <3795C94E.7CBA@yahoo.com>

Michel Lee wrote:
>
> I am using Dedicated Server process as oppose to MTS.
> so on in HPUX10.20 , ORACle 7.3.4
> each user connection creates a process like :
> oracleSIDNAME
>
> using 'top' this process takes up 10M of memory!
> (maybe i am interpreting this number wrongly)
>
> We have many users, e.g. 100 so, they all take up
> 100*10M=1000M=1G memory.
>
> This is creating 'out of mem' errors.
>
> My qustion is:
> Is that normal?
> What do i do to reduce this 10M per process mem usage?
>
> cheers
> Mike
> ------------
>
> --
> /-----------------------------------------------/ \--\--\ \-- \-- \--
> / www.ncf.carleton.ca/~ae299 /---\ \ \ \\ \ \
> / ae299_at_freenet.carleton.ca /-----\ \ \\-- \-- \--
> /-----------------------------------------------/

many process monitors include shared memory for processes as well...thus often if oracle processes are using 1m each and sharing a single 10m, then the process monitor reports that each is using 11m...

HTH
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Wed Jul 21 1999 - 08:21:18 CDT