Re: Tasks of an Oracle-DBA

"Paul Drake" <paled_at_home.com> wrote in message news:3B3AC7D2.F0C0FA34_at_home.com...
> Michiel wrote:
> >
> > actually, the best DBA tasks should be:
> > none!
> >
> > If you're a good DBA, all tasks should be initialized and automated... :
 a
> > normal server should be up at least for 500 days.
>
> what absolute crap.
>

absolutely.

First and just for the record, what are the current uptimes of your production instances Michiel?

select sysdate-trunc(startup_time) from v$instance will do it.

Second.

all tasks of a dba should be automated.

How do you automate

tuning poorly performing sql.
raising tars with oracle support (say an ora-00600 occurs) advising developers on new technology and development strategies applying os and or oracle patchsets

even automatable tasks such as adding a datafile to a tablespace often require at least a little bit of thought as to wether the standard procedure that you have should be followed in this instance.

--
Niall Litchfield
Oracle DBA
Audit Commission UK