Re: Info wanted: On-line reorg tool
From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Fri, 08 Mar 2002 22:04:53 +0000
Message-ID: <3C893585.2642_at_yahoo.com>
Date: Fri, 08 Mar 2002 22:04:53 +0000
Message-ID: <3C893585.2642_at_yahoo.com>
Vince Laurent wrote:
>
> I am looking at three tools:
>
> TSreorg from Computer Associates
> Space Expert from BMC
> Space manager from Quest
>
> We are running Oracle 8.1.x and SAP. Anyone have any experience with
> any of these? Any comments? Any suggestions as to what to ask vendors
> of database reorg tools? We are a 24x7 shop (hospitals) so downtime
> is VERY hard to get. One of the requirements is a on-line tool.
>
> Thanks for any information!
> Vince
Indexes can be rebuilt online which leaves just tables (which will be possible in 9i). Under most conditions, good choice of pctused/pctfree can avoid most table reorg requirements.
hth
connor
-- ============================== Connor McDonald http://www.oracledba.co.uk "Some days you're the pigeon, some days you're the statue..."Received on Fri Mar 08 2002 - 23:04:53 CET