Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> SYS is sorting to disk
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