Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> SYS is sorting to disk

SYS is sorting to disk

From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: 2000/03/04
Message-ID: <38c08c0c.6834606@news.earthlink.net>#1/1

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US