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 -> Re: SYS is sorting to disk

Re: SYS is sorting to disk

From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: 2000/03/05
Message-ID: <36e05f6e.198075023@news.earthlink.net>#1/1

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.



In case I forgot to mention:
We use Oracle 7.3.4 and 8.1.6 on Solaris 2.6, 2.7 boxes
Andrey Dmitriev	 eFax: (978) 383-5892  Daytime: (917) 750-3630
AOL: NetComrade	 ICQ: 11340726 remove NSPAM to email
Received on Sun Mar 05 2000 - 00:00:00 CST

Original text of this message

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