Re: Monthly maintenance

On Wed, 8 Nov 2006 11:13:57 -0000, "Lber" <lber_at_smartitc.co.uk> 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" <tcprof_at_tolan.fr> wrote in message
>news:u5d3l21fiu8bu8l26qtttdgq354vm281nr_at_4ax.com...
>> On Wed, 8 Nov 2006 10:25:03 -0000, "Lber" <lber_at_smartitc.co.uk> wrote:
>>
>>>Hi,
>>>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
>>>optimum
>>>levels?
>>>
>>>FYI it's an 8i server
>>>
>>>TIA
>>>
>>
>> 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
>>
>> http://tcprof.tolan.fr - 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

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