Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Anybody have experience of online reorg tools ?
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
>
> --
> Replace part of the email address: kennedy-down_with_spammers_at_attbi.com
> with family. Remove the negative part, keep the minus sign. You can figure
> it out.
> "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 Fri May 09 2003 - 02:42:49 CDT