Hello.
I am trying to find out wich sql code is creating the error ORA-01000 in my application (database release is 9.2.0.7). I have read this http://www.orafaq.com/node/758 and there they suggest doing this:
Sometimes you will need to get a full stack trace of the problem by setting a trace for ORA-1000 as in:
alter system set events = '1000 trace name ERRORSTACK level 3'
or...
alter session set events = '1000 trace name ERRORSTACK level 3'
Then set open_cursors to a low enough number to catch the open cursor voilator in your net.
I have no idea about this traces, so these are my questions:
1. Do those commands force a trace every time the ORA-01000 errors rises in every session? (I have forced the ORA-01000 error in one sqplusl session after I wrote "alter session set events = '1000 trace name ERRORSTACK level 3'" in another sqlplus session)
2. What does level 3 mean?
3. I see that in the dump/user directory I have several trace files, how can I know which error traces are enabled in my db?
4. How do I disable the traces once I find out to solve the problem?
5. How do I identify in the traces the ORA-1000 error?
Thanks in advance.