Re: Monthly maintenance

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.
Received on Wed Nov 08 2006 - 05:13:57 CST