Re: Database Maintenance

From: Dave Crowson <dcrowson_at_amoco.com>
Date: Thu, 26 Jan 1995 12:27:57
Message-ID: <dcrowson.806.000C77AA_at_amoco.com>

In article <3g488j$2au_at_ibridge.iohk.com> jwalters_at_igate.iohk.com (Jay Walters) writes:
>I am looking for information on what regular maintenance procedures a
>large ORACLE installation would perform on a regular basis in order to
>guarantee data integrity and service availability.
 

>On SYBASE one runs dbcc every day. Is there an analagous tool on ORACLE,
>and if not what steps does one take in keeping an ORACLE database up to
>snuff in a production environment.

IMHO, there is no simple answer to this, i.e. no one tool or program to do this.

Your best bet is to hire a good DBA, who will do this task for you.

(I'm _not_ available ATM:)

     Hit 'em in the face, with a funky bass, for a happy smiling race

David Crowson   =%^)    |"For my part, I travel not to go anywhere, but to go.
Oracle Consultant       | I travel for travel's sake. The great affair is to
(since 1983)            | move, to get down off this featherbed of civilisation
Amoco IT Services London| and to find the globe granite underneath and strewn
"My views alone "       | with cutting flints" : Robert Louis Stevenson

Replies: igotan_at_ombomb.demon.co.uk or weirdguy_at_cix.compulink.co.uk Received on Thu Jan 26 1995 - 12:27:57 CET