Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: defrag needed
Konstantinos Agouros wrote:
>
> In <c18ea449.0108200115.5e075ee_at_posting.google.com> crsoza_at_hotmail.com (C. R. Soza) writes:
>
> >The easiest way to avoid defrag is to size the tablespace with equi
> >extents and create table which inherits these storage attributes.
> What are equi-extends? Sorry if this question is stupid.
>
> Konstantin
> --
> Dipl-Inf. Konstantin Agouros aka Elwood Blues. Internet: elwood_at_agouros.de
> Otkerstr. 28, 81547 Muenchen, Germany. Tel +49 89 69370185
> ----------------------------------------------------------------------------
> "Captain, this ship will not sustain the forming of the cosmos." B'Elana Torres
THis is where (per tablespace) all extents are sized the same. By definition you will not have a fragmenation problem since every segment will be able to fit into any free space chunk in the tablespace
hth
connor
-- ============================== Connor McDonald http://www.oracledba.co.uk "Some days you're the pigeon, some days you're the statue..."Received on Tue Aug 21 2001 - 12:50:07 CDT