Re: Oracle Memory usage

Ken Johnson wrote:
>
> Binh Pham wrote:
> >
> > We have a Sparc 1000E with 256Meg RAM. How do I find out:
> > 1) How much memory currently being allocated solely to Oracle?
> > 2) How much is being allocated to SGA?
> > 3) How much memory or average currently being used by the whole system?

Show sga works really well from SQL*DBA.

Under solaris, there a number of things you can do to see memory usage including: ps, ipcs (inter process communication address information), vmstat and sar. You can also get a decent utility called "top" off the net that shows memory information. Any easy way to get average statics under Solaris is to enable the performance collection of sar. By default, the user sys has 3 sar jobs commented under cron that enable system performance statistic collection. See your man pages on sar for details.

---
Neil Greene
Sr Oracle DBA / Unix Admin
SHL Systemhouse, Inc.
Email: ngreene_at_laoc.SHL.com