Re: Memory utilization on Sun E3500.

Connor is right. Pengwin didn't mention which version of Solaris he is using. Solaris 2.6 claims as much memory for (file) caching. If the system needs memory then the allocated memory for cacheing is used. Solaris 2.8 behaves in a different manner. vmstat , look at the PI (kilobytes paged in), DE (anticipated short-term memory shortfall (Kbytes)), and SR (pages scanned by clock algorithm) entries, is better for taking conclusions.

kind regards,

Ivan

Connor McDonald wrote:

> pengwin wrote:
> >
> > 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
> > 7372 oracle 12 53 2 261M 218M sleep 0:02 0.00% oracle
> > 7370 oracle 14 53 2 258M 218M sleep 0:00 0.00% oracle
> > 7374 oracle 11 52 2 256M 218M sleep 0:33 0.00% oracle
> > 7376 oracle 1 42 2 256M 220M sleep 0:07 0.00% oracle
>
>
> Some of the tools under /usr/proc/bin are a better way of looking at
> memory usage. Probably one of the better ways of seeing whether you are
> genuninely facing memory starvation is to see how your scan rate is
> doing ('sr' under vmstat)
>
> hth
> connor
> --
> =========================
> Connor McDonald
> http://www.oracledba.co.uk
>
> "Some days you're the pigeon, some days you're the statue"
Received on Mon May 12 2003 - 04:50:00 CDT