Finally, SAP is doing something right. Yes, I agree LMT's are the way to
go.
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.
"Eric vd Spoel" <EpvdSpoel_at_hccnet.nl> wrote in message
news:b9m9qf$m4f$1_at_news.hccnet.nl...
> 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 - 15:11:51 CDT
