Re: Help:Memory set for Solaris Box

"basrad_at_oraspec.ind" <daekw_at_yahoo.com> wrote in message news:afjvru$9de$03$2_at_news.t-online.com...
> this new version of oracle or so full ob bug
> with 7 we never had this problems
> you always need to restart the server to get your memory back
>
> sort area should never be more than 16 k
>

Quite the worst piece of advice I've seen for a long time, if it was serious. And my apologies for being a grumpy old man if you weren't.

Regards
HR

>
> "Joe Sath" <dbadba62_at_hotmail.com> schrieb im Newsbeitrag
> news:cU5T8.2337$vr5.1792_at_nwrddc01.gnilink.net...
> > I am posting my question here because I know many good DBAs are also
good
> > SAs.
> >
> > We are currently using Oracle 817 on Solaris 2.7
> >
> > We have 2G memory.
> > I set db buffer 800MB (which 300MB for keep, 100MB for recycle)
> > SGA we set 200MB
> > sort_area_size we set at 1M
> >
> > From top command, I can see there is always 1000MB swap memory in use.
> > From vmstat, I can see there is high page-in, page-out, (about 100, 300)
> and
> > sr (around 10) is also very high, does this mean I have put too much
> memory
> > for Oracle? What is the good size I should assign for Oracle?
> >
> > I do not see any performance issue yet, all the hit ratio, both db
buffer
> > hit and libray are close to 100%. But just curious.
> >
> >
> >
>
>
Received on Sat Jun 29 2002 - 07:33:03 CDT