Re: Database Outages - Best Practices

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Thu, 17 Feb 2005 09:05:13 +0000
Message-ID: <7765c89705021701056beba1a8@mail.gmail.com>

On Mon, 14 Feb 2005 15:26:54 -0600, Hollis, Les <Les.Hollis_at_ps.net> 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
--
http://www.freelists.org/webpage/oracle-l

Received on Thu Feb 17 2005 - 04:08:22 CST