Re: Track Query that crash the system

From: Brian Peasland <oracle_dba_at_peasland.com>
Date: Wed, 20 Nov 2002 16:47:56 GMT
Message-ID: <3DDBBCBC.C1DEABA2@peasland.com>

After the database crash, the contents of all V$ views will be wiped out. So once your database is back up and running, you won't be able to go back in and determine what was running before the crash.

HTH,
Brian

chuaby wrote:
>
> Hi
>
> 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 ?
>
> Thanks
> Boon Yiang
Received on Wed Nov 20 2002 - 10:47:56 CST