Re: Memory utilization on Sun E3500.

"pengwin" <nospam_at_localhost.com> wrote in message news:<3ebf3874$0$52255$c30e37c6_at_lon-reader.news.telstra.net>...
> Hi all, we have a "development" Oracle Database on our Sun E3500. It is chewing
> up my RAM big time and impacting on other processes, notably the "Live"
> accounting System.
>
> Our DBA, who is also the IT Manager claims that the following blocks of Memory
> are not legit, and/or a single block of 260Mb. I laugh at him when he says this,
> but he seems to be serious/convinced that Oracle is not chewing up the RAM. I
> just want to get a second opinion, am I right in saying Oracle is to blame for
> us constantly paging?
>
> This is a top sorted by "size" Comments please? If we shutdown Oracle, how do we
> force Oracle to release the RAM (Other than a restart).
>
> load averages: 1.67, 1.58, 1.69 15:46:24
> 459 processes: 456 sleeping, 3 on cpu
> CPU states: 51.9% idle, 38.8% user, 7.3% kernel, 2.0% iowait, 0.0% swap
> Memory: 1792M real, 27M free, 705M swap in use, 3703M swap free
>
> PID USERNAME THR PRI NICE SIZE RES STATE TIME CPU COMMAND
> 12386 oracle 1 26 0 262M 218M sleep 0:00 0.00% oracle
> 12643 oracle 1 18 0 261M 218M sleep 0:00 0.00% oracle
...

I don't think you can deduce the memory usage of Oracle with tops, 95% of the size may be shared memory. Don't you have an "ipcs"?

Anyway, if the number of oracle-processes would bother you, Oracle invented MTS, one background process serving multiple clients. But avoid it when the client is a batch-process.

I happen to notice the "0.0% swap" in your tops-output. Didn't you say you were constantly paging? The "CPU states" look rather healthy to me.

Gerard Received on Mon May 12 2003 - 07:05:03 CDT