Re: guide on impact of system

Ben wrote:
> i guess version 8i or 9i.
> Anything from creating tables to dropping, truncating, adding
> datafiles, building indexes, coalescing, analyzing, deallocating, alter
> table, alter index.
> I haven't seen anywhere in the manuals that say what impact these
> actions have on performance. They just give you the keys and let you
> take off.

It depends. Creating a table can be very fast, or you can have options that take a long time.
Dropping and truncating can be very fast, unless something locks them out.
Adding datafiles is generally slow, oracle must "format" the files. Building indices requires scanning through something, how fast is determined by what.
Analyzing is dependent on how much you want to analyze. Alter table can just be an update to a system table, or may update every block.
All of the above may be affected by what else is going on in the system, so as always, the answer is "it depends." You need to test and learn for your own configuration. Many people publish what they find, too, like http://www.jlcomp.demon.co.uk/faq/ind_rebuild.html . Jonathan Lewis' Practical Oracle8i is a classic.

jg

--
@home.com is bogus.
McNealy quotes:
http://www.businessreviewonline.com/blog/archives/2006/04/best_mcnealy_qu.html