Re: Help:Memory set for Solaris Box

I am more of a Win2k DBA, but...

If you see lots of paging and your cache hits are good, just lower the mem usage a bit and wait a few day, chekc again. Keep this up until you are happy with the results. Then just check ever one and a while to make sure you are still happy. Might also want to think about getting some more mem. for the server. Usally cheaper than the time it takes to get all the settings 100% :)

"Joe Sath" <dbadba62_at_hotmail.com> wrote in message 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 Fri Jun 28 2002 - 21:15:01 CDT