Re: SYS is sorting to disk

When I upped SORT_AREA_RETAINED_SIZE to 128K the problem seemed to have gone away, but I still would like to know someone's opinion why this happenned in the first place, since my sort_area_size is 16M.

Unfortunately all my other DB's are configured with retained size of 1m, so I can't compare to them (and they're Ora7 anyway), but I have a different 8i db which has 64K of retained size and is not showing any temp problems.

Thanx again.

On Sat, 04 Mar 2000 04:08:50 GMT, andreyNSPAM_at_bookexchange.net (NetComrade ) wrote:

>I set up a new db with a fairly large TEMP tablespace, later on I
>started getting pages that I am running out of TEMP space. So I
>started looking for the problem.
>
>I found that SYS schema is sorting to disk, and even when I decreased
>INITIAL and NEXT default TEMP extents to 1/16th of SORT_AREA_SIZE, SYS
>is still writing to disk, and in exactly 1M segments (my latest
>defualt Initial and NEXT)
>
>So it looks like SYS is avoiding sorting in memory, does anybody know
>why?
>
>Thanx.
Received on Sat Mar 04 2000 - 00:00:00 CST