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: Does the number of extents affect the performance?

Re: Does the number of extents affect the performance?

From: Roald van Geleuken <roald_at_xs4all.nl>
Date: 1997/09/15
Message-ID: <5vjpng$6u2$1@news2.xs4all.nl>#1/1

 I don't agree with this. I'm working on a project where we found that when the number of extents exceeded about 40 (differs per table), we got a significant performance loss. After export/import to a single extent, the performance would go up again, until again the extent count would go over the magic mark.

It seems that the recordsize of the table has something to do with it. The bigger the record, the faster the number of extents will reach the magic mark. As I said, this magic mark differs per table. A quick solution is to set the next_extent to a big value, although this might give problems with available tablespace-space.

Like to hear other opinions.

Roald.

roald_at_xs4all.nl

Nuno Souto wrote in article <341D1B62.2607_at_acay.com.au>...

>
>>But hasn't Mohamed demonstrated the pathological worst case ? Is this
>>typical ?
>>
>>We still want to answer the original question of "As far as performance
>>goes, do extents matter ?". And the answer seems to be "It -almost-
>>never is an issue." Shouldn't we ?
>>
>
>In most cases they don't. Like anything, there are pathological cases.
>To me, going through all the trouble of religiously de-fragging every
>night just to make sure the worst case doesn't happen is the equivalent
>of changing the oil on your car every time it rains: we all know water
>can enter the oil and stuff up the engine, but do you change the oil as
>soon as it finishes raining? Or do you just check the dipstick?
>
>Same here: why go through all the trouble when there are ways of
>checking if fragmentation is a problem? If it is, fix it. And correct
>the allocation so that it doesn't happen again at least on that object.
>If it is not, then why bother? There are much better ways of using your
>knowledge and time as a DBA than to do repetitive drone work every night
>just because on a blue moon and if the wind is blowing from the NNE, the
>performance might drop.
>
>
>
>--
>--
>Nuno Souto
>nsouto_at_FOSPAMacay.com.au
Received on Mon Sep 15 1997 - 00:00:00 CDT

Original text of this message

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