Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Usenet -> c.d.o.server -> Re: Monthly maintenance

Re: Monthly maintenance

From: Tom Churchward <>
Date: Wed, 08 Nov 2006 12:43:35 +0100
Message-ID: <>

On Wed, 8 Nov 2006 11:13:57 -0000, "Lber" <> wrote:

>Hi thanks for the reply,
> by optimal i mean that the database is running as quick as it can, that is
>kept in peak condition, so that uses do not complain that it slow to
>function etc.
>patching is not really an issue, as i have a test enviroment which is used
>to try out patches before deploying them, and this can take time. I'm not
>really worried about that.
>I'm just looking for a guide on good houskeeping for oracle i guess
>"Tom Churchward" <> wrote in message
>> On Wed, 8 Nov 2006 10:25:03 -0000, "Lber" <> wrote:
>>>I'm in the process of setting up an Oracle server.
>>>what sort of maintenance does Oracle need to keep it running at it's
>>>FYI it's an 8i server
>> I wonder if you could approach this from a different angle? What does
>> the Business you work for regard as optimal? They will have
>> priorities which perhaps aren't quite the same as yours. Taking a
>> crude example: if their priority is application/database available at
>> 9am each morning then you'd better make sure it is running at 9am each
>> morning - your business users might argue that the system is optimal
>> if it's available at 9am each morning....
>> I guess the question wasn't really about this type of thing but it
>> might be worth asking them to define 'optimal' rather than using a
>> list of items such as, each logical I/O should take less that 10micro
>> seconds, each disk read less than, must keep up-to-date with patches
>> etc.
>> Just a thought.
>> Tom Churchwad
>> - The home of tcprof, an Oracle 10046 Trace
>> File Profiler.

So we come back to which business tasks are regarded as priorities. These priority tasks are the ones you should focus your efforts on - forget about making the database optimal - keep these critical tasks serving the Busniess within agreed time limits. Do this and your boss will be happy with you because his/her boss will say something along the lines of " hey the database is running just great!" That's what I do for my clients whenever they say "my database is slow": I focus on what matters to the Business.

Hope this helps

Tom Churchwad - The home of tcprof, an Oracle 10046 Trace File Profiler. Received on Wed Nov 08 2006 - 05:43:35 CST

Original text of this message