Re: guide on impact of system

From: NetComrade <netcomradeNSPAM_at_bookexchange.net>
Date: Thu, 27 Apr 2006 15:53:01 -0400
Message-ID: <p582525ov9jf9ibumeg5l8mbgeftr46sc1@4ax.com>

On 27 Apr 2006 11:21:53 -0700, "Ben" <balvey_at_comcast.net> wrote:

>the response, "it depends" is about as usual as birdshit on a pump
>handle.
>
>thanks for the references. In other words, there is no set guide that
>tells us, "this should be done during off hours, and this can be done
>at anytime".

You have to understand what the database does on the background, in order to understand you have to learn by reading appropriate documentation.

here's a 'depends' example:
If your table contains of 300000 extents and you drop it, it'll be expensive in the case of 'dictionary managed' tablespace, and not so expensive in the case of 'locally managed' tablespace. .......
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:53:01 CDT