Re: memory and page faults (continued)
- From: "Green, Simon" <Simon.Green@xxxxxxxxxxxxx>
- Date: Sun, 29 Jan 2006 13:28:11 +0100
Title: Message
|
Minperm/Maxperm will have the largest
effect.
Different systems will have different
settings - it depends on the DB configuration, the amount of memory, the load on
the system, the non-DB load etc.
Really, the only way to get it right is to
try it and see, then change it a little bit if it's not right. Values of
3-8 or 5-10 look about right to me; 15-40 is a bit conservative for a system
with a decent amount of memory. What it's controlling is how much
memory to keep for normal filesystem access, and how much to just leave alone,
which is what will be available to the DB to use - for SGA. Obviously you
need to have Oracle configured to use this memory, otherwise you'll stop the
paging, (which will have a positive effect) but not get full use of
the system's resources.
--
Simon
Green
AIX-L Archive at
https://new-lists.princeton.edu/listserv/aix-l.html New to
AIX?
http://publib-b.boulder.ibm.com/redbooks.nsf/portals/UNIX N.B. Unsolicited email
from vendors will not be appreciated. Please post all
follow-ups to the list.
|
- Prev by Date: Re: memory and page faults (continued)
- Next by Date: Re: ksh script question
- Previous by thread: Re: memory and page faults (continued)
- Next by thread: Re: memory and page faults (continued)
- Index(es):
Relevant Pages
|
