Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Questions for reorg in Oracle Database
Shyam Sharma wrote:
>
> Dear users,
>
> Here are some of my general questions for performing reorg in a Oracle
> Database, I would appreciate if someone could take some time to answer
> some/all of these questions:
>
> 1. What types of objects do we need to reorganize most often
> Tablespaces/Tables/Indexes/Whole databases ?
> 2. What are the tools available in the market, to perform reorganizations ?
> 3. What information do we need to have about an object before doing a reorg
> ?
> 4. What information do we need to have about an object during a reorg ?
> 5. What information do we need to have about an an object after a reorg
> 6. What minimal functionality should a reorg tool have, if we want to buy
> one?
> 7. What additional functionality can be added for effeciency?
>
> Thanks
>
> Shyam
Go to www.orapub.com - you'll find that with a little work you probably won't need to reorg anything...ever!
HTH
--
"Some days you're the pigeon, and some days you're the statue." Received on Tue Jan 04 2000 - 05:16:45 CST