Re: Please Help: with tuning database

sirirut vanichayobon wrote:

> Dear All,
>
> I am using Oracle9i on Linux. I have encountered one problem. The
> problem is the database was hang while there were only 5-6 users. I
> have to shutdown and then start the database to slove the problem.
> I checked space on memory and datafiles. Both are fine. What
> should I check or tune my database to avoid this kind of problem?
> Any suggestions would be appreciated.
>
> Thanks in advance,
>
> sirirut

I would check for wait events.
I would check the alert log.
I would check any trace files.
I would check to see what other processes might be going on at that moment on that machine or on the network. (I once had a case of this that drove us nuts until we found a backup process that had been incorrectly timed for 2:00pm (afternoon) rather than 2:00am (middle of the night).

Daniel Morgan Received on Fri Jul 12 2002 - 10:07:56 CDT