Re: can poor tuning cause database crashes

chrisoc_at_ans.net wrote:
>
> We're running Oracle 7.3.2 on Solaris. We have a heavily loaded
> (at times) database which crashes occasionally. Some argue that
> the database is poorly tuned and this can cause the DBWR process to
> just die. I'm new to Oracle but my experience with other DB products
> leads me to suspect tuning in performance issues but not as a cause
> of crashing behavior per se.
>
> Yes we have seen the demise of the DBWR and are planning to upgrade
> to 7.3.3 -- but I seek opinions/experience stories as to whether
> a database can be so out of tune as to crash.
>
> Chris O'Connor
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/ Now offering spam-free web-based newsreading

Hi Chris

I haven't such problems, but did you have a look at the alert file after the system has crashed ? There you might see oracle errors which can give you a hint (e.g.ORA-600 [] )

rgds
eugen Received on Tue Mar 03 1998 - 00:00:00 CST