Re: Help:Memory set for Solaris Box

From: <basrad_at_oraspec.ind>
Date: Sat, 29 Jun 2002 11:59:57 +0200
Message-ID: <afjvru$9de$03$2@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

"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 - 04:59:57 CDT