Re: Periodic restart DB recommended or no ?

"Rahan" <Rahan_at_rahan.net> wrote in message news:47ef8456$0$7174$426a74cc_at_news.free.fr...
> Hello everybody,
>
> Usually, what are the reasons why you have to stop and restart the
> database ?
>
> Perhaps, for somes maintenance like :
> - check integrity of the database ?
> - cleanup the buffer (SGA/PGA) ?
> - reduce the problems related the DB processes ?
> - cleaup the redo log file ?
> - make a clean system backup ?
> - resize tablespace, segment or update redo log file... ?
>
> so, i would like to list the main actions recommended requiring a stop of
> the database.
>
> Could you advice please.
>
> Thanks a lot
> Regards
>
>

To cleanup memory leaks perhaps ... but I don't know if that's the case for Oracle software ... Received on Sun Mar 30 2008 - 12:34:17 CDT