(Pardon me if you already know this or if my understanding is
incomplete. Check this with your SA.)
On Solaris (and other unixes?) you can 't look at the %swap stat on
top, for example. My SAs tell me that Solaris will only start
swapping full processes when it is about to die from lack of memory.
On the other hand, it 'll page parts of a process 's memory space as
memory gets tight. The SGA is supposed to be "pinned " in physical
memory, I believe, but it 'll page it out if forced by lack of memory.
If the SGA is getting paged, well, performance on a heavily used
system will in most cases go out the window.
But maybe what you mean by "no swapping " is what I mean by "no paging "
and I 'm barking up the wrong tree. Or, as you suggest, your SGA is
fine but you are blowing out your RAID cache.
Steven
--
http://www.freelists.org/webpage/oracle-l
