Re: Anybody have experience of online reorg tools ?

Jim,

SAP advises to use Locally Managed Tablespaces(LMT's). This is not only faster in use but you don't have to worry about different next extent sizes anymore. If you have a tablespaces with tables or indexes which have large next extent sizes you can use the option uniform extent size, example: 320 Mb
Btw If you move a table to the TS it is in now, you rebuild it and so winning the space you want.

Eric

"Neil Cudd" <neil_at_cudd.demon.co.uk> schreef in bericht news:190d457f.0305082342.2b28455a_at_posting.google.com...
> Hi Jim,
> performance is really not the driver here. Trying to reclaim disk
> space on large systems and apply uniform extent management where it is
> not at the moment.
> Thanks,
> Neil.
>
>
> "Jim Kennedy" <kennedy-down_with_spammers_at_attbi.com> wrote in message
news:<bZDua.539829$Zo.115007_at_sccrnsc03>...
> > Also ask yourself why are you doing this? Measure the performance
before
> > and after and see if it really made a difference.
> > Jim
> >

> > "Antoine BRUNEL" <antoinebrunel/yahoo.fr> wrote in message
> > news:3ebaf8e0$0$7947$79c14f64_at_nan-newsreader-01.noos.net...
> > > Beginning with 8i, and even mostly with 9i, you are now able to move
> > objects
> > > without altering their availabity:
> > >
> > > alter table XX move....
> > > alter index XXX rebuild ...
> > >
> > > theses SQL can be parallelized (degree X), nologging.
> > >
> > > In 92, there are packages specific for online table reorg.
> > >
> > >
> > >
> > > "Neil Cudd" <neil_at_cudd.demon.co.uk> a écrit dans le message de
> > > news:190d457f.0305081632.4a38cbec_at_posting.google.com...
> > > > I'm to make recommendations and was wondering if anybody out there
has
> > > > experience of an online reorg tools and would care to share their
> > > > experiences.
> > > >
> > > > My platform is primarily 9i 64bit on aix 5.1 - SAP systems.
> > > >
> > > > Any pointers gratefully received.
> > > >
> > > > Thanks,
> > > >
> > > > Neil.
> > >
> > >
Received on Sun May 11 2003 - 14:52:21 CDT