Try this:

A shell script calling sql env to ANALYZE certain table. kill the process running the 
shell script before it is done. You might get ora-00600 with argumrnt[1113]

Thanks
Pradhan

--------------------------------


On Wed, 08 Oct 2003 Sinardy Xing wrote :
>ora-600 may result your db down or crash
>
>-----Original Message-----
>Sent: 08 October 2003 10:09
>To: Multiple recipients of list ORACLE-L
>
>
>I want the DB to see and act on an ORA-00600, not just record
>one in the alertSID.log
>
>Thanks,
>Mike
>
>
>-----Original Message-----
>Sent: Tuesday, October 07, 2003 6:54 PM
>To: Multiple recipients of list ORACLE-L
>
>
>did you just want to see it in an alert.log?  or are you working with a
>dump?
>
>joe
>
>
>Vergara, Michael (TEM) wrote:
>
> >Ok...strange request time.  I want to test a script that I found
> >on the DBA Village web site.  It's supposed to capture some
> >information whenever there's a DB error.
> >
> >Does anybody know how to trigger a 'benign' ORA-600 so I can test
> >this functionality?
> >
> >Thanks,
> >Mike
> >
> >
> >---
> >===========================================================================
> >Michael P. Vergara
> >Oracle DBA
> >Guidant Corporation
> >
> >
> >
>
>--
>Joseph S Testa
>Chief Technology Officer
>Data Management Consulting
>614-791-9000
>It's all about the "CACHE"
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Joe Testa
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
>San Diego, California        -- Mailing list and web hosting services
>---------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Vergara, Michael (TEM)
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
>San Diego, California        -- Mailing list and web hosting services
>---------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Sinardy Xing
>   INET: [EMAIL PROTECTED]
>
>Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
>San Diego, California        -- Mailing list and web hosting services
>---------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from).  You may
>also send the HELP command for other information (like subscribing).

Reply via email to