Re: guide on impact of system

From: NetComrade <netcomradeNSPAM_at_bookexchange.net>
Date: Thu, 27 Apr 2006 15:50:24 -0400
Message-ID: <828252d2dtglbtfu8tbmbmjlljr222293e@4ax.com>

On 26 Apr 2006 10:01:55 -0700, "Ben" <balvey_at_comcast.net> 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.

I am afraid you need to refer to the concepts guide. A lot of these things can be quite expensive, and rebuilding indexes if not done in 'online' mode can 'freeze' the database (not doing online mode).. analyzing can invalidate a lot of sql, and you will have library cache contention.. etc, etc..

.......
We run Oracle 9.2.0.6 on RH4 AMD
we are currently looking for a DBA
remove NSPAM to email Received on Thu Apr 27 2006 - 14:50:24 CDT