Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Indexed Tablespace Fragmentation
out of interest what size points do you generally pick for your extent
sizes? and is there a reason for favouring particular sizes rather than
sizes that differ by say 1000 times or so.
-- Niall Litchfield Oracle DBA Audit Commission UK ***************************************** Please include version and platform and SQL where applicable It makes life easier and increases the likelihood of a good answer ****************************************** "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:1020168287.14110.0.nnrp-13.9e984b29_at_news.demon.co.uk...Received on Tue Apr 30 2002 - 08:05:31 CDT
>
> Yes.
>
> But almost entirely for management reasons.
> If a segment in an LMT has more than a few
> dozen segments - and is still growing - it
> should be in the 'next size up' tablespace.
>
>
> --
> Jonathan Lewis
> http://www.jlcomp.demon.co.uk
>
> Author of:
> Practical Oracle 8i: Building Efficient Databases
>
> Next Seminar - Australia - July/August
> http://www.jlcomp.demon.co.uk/seminar.html
>
> Host to The Co-Operative Oracle Users' FAQ
> http://www.jlcomp.demon.co.uk/faq/ind_faq.html
>
>
>
> Nuno Souto wrote in message
> <3cce7a59$0$15477$afc38c87_at_news.optusnet.com.au>...
> >In article <1020117147.18578.0.nnrp-12.9e984b29_at_news.demon.co.uk>, you
> >said (and I quote):
> >>
> >> There's a difference between
> >> extents per segment
> >> and
> >> extents per tablespace
> >
> >yup.
> >
> >>
> >> One reason I like to keep extents per segment
> >> quite low (ideally a few dozen, worst case a
> >> couple of hundred) is to ensure that the
> >> tablespace as a whole doesn't end up
> >> with huge number of extents.
> >
> >Is that for lmt AND dmt?
> >
> >
> >--
> >Cheers
> >Nuno Souto
> >nsouto_at_optushome.com.au.nospam
>
>