Oracle Stacktrace

Here is how you can watch for a certain ORA- error and dump a stack trace.

Systemwide:

make a backup of the spfile and then run this for an ORA-01410

SQL> alter system set event='1410 trace name ERRORSTACK level 3' scope=spfile;

Then restart the database.

If the error happens on a certain session you can do it on the fly for that session only:

alter session set events '1410 trace name ERRORSTACK level 3';