Re: Anybody have experience of online reorg tools ?

I agree with Connor. Once I did reorg a db, and the only thing that changed significantly was 2GB less space requirement. Well, at least that ... I could not see any other boosting effects by having done it. So I took it as yet another experience.

Jan

"Connor McDonald" <connor_mcdonald_at_yahoo.com> schrieb im Newsbeitrag news:3EBB2C29.17B2_at_yahoo.com...
> Neil Cudd wrote:
> >
> > 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.
>
> I'm curious as to what metric you are intending to improve by
> re-orging. (I'm not being facetious here, just trying to stress that
> re-orging isn't worth the effort unless there is a definable and
> measurable result to the exercise)
>
> hth
> connor
> --
> =========================
> Connor McDonald
> http://www.oracledba.co.uk
>
> "Some days you're the pigeon, some days you're the statue"
Received on Fri May 09 2003 - 01:55:36 CDT