Re: Tracing an ORA-01410 error

From: Stefan Knecht <knecht.stefan_at_gmail.com>
Date: Fri, 6 Feb 2009 13:29:09 +0100
Message-ID: <486b2b610902060429o394837e7i1f4cd8e89c68390f_at_mail.gmail.com>

If you're experiencing ORA-1401, but set the errorstack trace for ORA-1440 -- you will not see any information at all :)

The number you're putting into the alter session command has to be the number of the oracle-error you're getting. You'll see a tracefile with the stacktrace and the current sql statement executing (along with a whole lot of other information). Just try it out, no harm done:

alter session set events '942 trace name errorstack level 1';

select * from does_not_exist; -- this causes ora-942

then check your user_dump_dest for the tracefile.

Cheers

Stefan

On Thu, Feb 5, 2009 at 10:12 PM, Schauss, R. Peter (IT) < peter.schauss_at_ngc.com> wrote:

> Oracle 8.1.7.4/ Solaris 9
>
> Some of our user reports are failing with ORA-1401- invalid rowid
> errors. Searching the archives I found a suggestion that I turn on
> tracing for this error with the command:
>
> alter session set events '1440 trace name errorstack forever, level 3';
>
> What kind of information can I expect to get from this trace?
>
> Thanks,
> Peter Schauss
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Feb 06 2009 - 06:29:09 CST