"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message news:<pan.2003.02.10.00.12.46.742705_at_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
Nope. There is no chance of anybody changing the sort_area_size using
alter session command. But we increased the sort_area_size from 64k to
200k 2 months ago. Active users in our system at the peak time will be
around 20(status active in v$session).
Received on Wed Feb 12 2003 - 06:55:03 CST
