Java Mailing List Archive

http://www.dba.5341.com/

Home » Home (12/2007) » oracle l »

Can't get rid of event "1403 trace name errorstack"

Stefan Knecht

2006-06-19

Replies:

Hello list,

at a client, we've set event 1403 trace name errorstack to track down a  batch process that exits with this error, and have therefore set the event using

alter system set events '1403 trace name errorstack level 1';

which worked fine.

but now, we can't get rid of the event anymore, even after turning it off using

alter system set events '1403 trace name errorstack off';

there are still *occasional* entries in the alert log of an ora-1403 happening (not as frequently as when it was active in the whole instance - which was a lot as Oracle internally raises this event with virtually every select statement -- see note 271490.1 ).



database will be bounced tonight either way - but I'd like to know why this happened, and how to get rid of it in case it would happen to me again



Regards Stefan
©2008 dba.5341.com - Jax Systems, LLC, U.S.A.