Re: Oracle 8.1.17 extent management
- From: "Andrew Kerber" <andrew.kerber@xxxxxxxxx>
- To: JDunn@xxxxxxxxx
- Date: Fri, 20 Jun 2008 07:51:02 -0500
Locally managed fixed 1 meg extents (initial 1m, next 1m, pctincrease 0)
works real well.
On Fri, Jun 20, 2008 at 6:36 AM, John Dunn <JDunn@xxxxxxxxx> wrote:
> In have a customer still runing 8.1.7. They were having performance
> issues which appeared to be due to frgmentation. An export and import solved
> the performance issue.
>
> They are due to move to Orcale 10 soon, but in the mean time what can they
> do to minimise fragmentation on 8.1.7.
>
> Move to locally managed tablespaces? Change the next extent values(which
> appear to be very small) ?
>
>
>
> John Dunn
>
> Product Consultant
>
> Sefas Innovation Limited
>
> Direct Dial + 44 (0) 117 373 6122
>
> *www.sefas.com*
>
> Sefas Innovation Ltd, CityPoint, Temple Gate, Bristol BS1 6PL, UK. Tel: +44
> (0) 117 373 6114 Fax: +44 (0) 117 373 6115
>
> *Sefas Innovation Limited. *Registered No: 3769761 England. Registered
> Office: One New Street, Wells, Somerset, BA5 2LA, United Kingdom. VAT
> Registration No: GB 741 5377 32
>
> Unless stated to be non-confidential, this email and any attachments are
> private and confidential and are for the addressee only. Sefas monitors
> e-mails to ensure its systems operate effectively and to minimize the risk
> of viruses. Whilst Sefas has taken reasonable steps to scan this email, it
> does not accept liability for any virus that may be contained in it.
>
> Internet communications are not 100% secure and as such Sefas is not
> responsible for their abuse by 3rd parties, nor for any alteration or
> corruption in transmission.
>
>
>
--
Andrew W. Kerber
'If at first you dont succeed, dont take up skydiving.'
Other related posts:
