Re: Track Query that crash the system

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: Tue, 19 Nov 2002 13:29:20 +0200
Message-ID: <ard7da$fdv$2@ctb-nnrp2.saix.net>

chuaby wrote:

> I have a DB crash. May i know is there anyway for me to track which
> query that causes the db to crash so that we can fine tune that query
> ?
> can i tell from eg V$SQL view ?

What makes you think that it was a "bad" SQL?

Have you checked the alert log? Are there any trace files? (there should be).

What Oracle version are you running? What platform? What were the crash error message?

Oracle does not just crash for the heck of it. SQLs are not likely to cause a db to fall over and crash (not impossible, but unlikely).

One fine tunes queries when suffering performance issues. Not when a database crashes. IMO.

--
Billy

Received on Tue Nov 19 2002 - 05:29:20 CST