Re: Question on Installing Oracle.

No, I believe they are set to 0. I know that 50 or 100 will reduce the fragmentation but it is like pulling teeth to get anyone to listen.

Do you think that because it is 0 that is causing most of the problem? I know the with 0 the extents will be uniform in size thus reducing wasted space. But again I need to reduce the number of extents.

Thanks.

On Wed, 16 May 2001 02:00:59 +0200, Bruno Jargot <bjargot_at_club-internet.fr> wrote:

>On Tue, 15 May 2001 21:37:53 GMT, Kev.- wrote:
>
>>Hello Howard,
>>
>>>Who cares if it's too small? Autoextend is set to on by default (for
>>>SYSTEM), and so when it needs more space, you get it. You haven't been daft
>>>enough to stop it autoextending, have you? SYSTEM must never run out of
>>>space.
>>No I am not daft enough to do that. BUt when I query to see the
>>extents it shows that the system and catalog are well over 300
>>extents. This just seems like alot of extents to me and it is getting
>>worse by the day.
>
>One question :
>The pctincrease of the tablespace SYSTEM is 50, isn't it ? And all the
>segments in the tablespace SYSTEM have a pctincrease of 50 ?
  Received on Tue May 15 2001 - 20:12:18 CDT