Re: Database Outages - Best Practices
- From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- To: Les.Hollis@xxxxxx
- Date: Thu, 17 Feb 2005 09:05:13 +0000
On Mon, 14 Feb 2005 15:26:54 -0600, Hollis, Les <Les.Hollis@xxxxxx> wrote:
> We call it a 'maintenance window'...
>
> ALL databases require periodic maintenance
This I agree with
> Rebuilding indexes
This I don't - but if you are going to do it - do it online without an outage.
> Running in new application code
> Table reorgs (Typically after huge deletes as in a table purge..)
I'm not necessarily sure I agree with this one either, it maybe that
the cost of the downtime doesn't justify it.
> Tablespace rebuilds
As before. What is the cost of not doing it compared to doing it. In dollars.
I'm interested that you don't include patching the database or os in your list.
--
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
--
//www.freelists.org/webpage/oracle-l
Other related posts:
