Re: page_in values in vmstat output

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Mon, 10 Feb 2003 11:12:47 +1100
Message-ID: <pan.2003.02.10.00.12.46.742705@yahoo.com.au>

I wouldn't know much about Solaris internals, but you don't, perchance, have a weird and wacky setting for sort_area_size or other _area_size parameters, do you?

Bit of a long shot, what with the amount of memory you've got there, but the SGA is not the only drain on system memory that Oracle makes. The PGA (the largest component of which is governed by sort_area_size) also needs to be taken into account.

You might have some smart-alec doing 'alter session set sort_area_size=9000000000' or something daft.

Just a thought.
Regards
HJR Received on Sun Feb 09 2003 - 18:12:47 CST