Re: can poor tuning cause database crashes

From: Steve Phelan <stevep_at_XXnospamXX.toneline.demon.co.uk>
Date: 1998/03/03
Message-ID: <888917462.14146.0.nnrp-09.c2de712e@news.demon.co.uk>#1/1

Irrespective of the crashes, you SHOULD tune and monitor your database anyhow.

As regards the crashes, have you checked the Oracle log files for more info.? Have you contacted Oracle Support? You need to get more info. on what is actually causing the 'crashes'.

Things I can think of (apart from first checking your alert logs) are:

Do you have enough free space inside your database (i.e. all tablespaces)?
Do you have enough free disk space outside your database?
Do you have excessive fragmentation (both inside and outside the db)?
Have you installed all the required OS patches for your Oracle release?
Have you installed any Oracle patches that may be required?
Have you read the README that comes with the installation?
Are the UNIX environment variables set-up correctly?
Are you giving the SGA sufficient RAM (real, with no paging)?
Have you gone through the installation guide AND INSTALL NOTES in detail?

I've used Oracle on most UNIX platforms and found it remarkably stable. Not perfect, sure, but not prone to crashing unexpectedly either. You should NOT have to suffer random crashes. We certainly couldn't afford that in our business.

Steve Phelan.

chrisoc_at_ans.net wrote in message <6df62a$5pt$1_at_nnrp1.dejanews.com>...
>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
Received on Tue Mar 03 1998 - 00:00:00 CST