Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to perform a health check?
Hans Forbrich wrote:
> Brian Dick wrote:
>> On Wed, 29 Sep 2004 21:48:28 -0700, Daniel Morgan wrote: >>
>>>> Hi everyone, >>>> >>>> In order to maintain an oracle database in an optimal condition, good >>>> maintenance is a necessity. >>>> >>>> Can anyone show me how to carry out a good health check of an oracle 8i >>>> database? >>>> >>>> Thanks in advance.
> OR (esp. if you aren't hearing the complaints) you are about to get a very > nasty surprise!
If no one is complaigning then I would suggest
1- take a look at the space utilization paying close attention to how much
fre space is available to each tablespace and how much space any object is
likely to request
2- review the alert log and trace files for any indication of errors or
unreported problems that may be occurring
3- run a statspack report during what should be prime time and see what it
tells you
HTH -- Mark D Powell --
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=