Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: SYS is sorting to disk
We use CHOOSE, but I never analyze anything. I am happy with RULE in our OLTP environment
On Sat, 04 Mar 2000 05:50:32 GMT, yong321_at_yahoo.com wrote:
>In article <38c0906e.7956761_at_news.earthlink.net>,
> andreyNSPAM_at_bookexchange.net wrote:
>> 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.
>>
>>
>
>Is it possible your SYS schema has been analyzed? If so, do this:
>
>dbms_utility.analyze_schema('sys', 'delete', null)
>
>--
>Yong Huang
>
>(yong321_at_yahoo.com)
>(http://www.stormloader.com/yonghuang/)
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Andrey Dmitriev eFax: (978) 383-5892 Daytime: (917) 750-3630 AOL: NetComrade ICQ: 11340726 remove NSPAM to emailReceived on Sun Mar 05 2000 - 00:00:00 CST
![]() |
![]() |