Setting a Trace - URGENT

[joyce_ank]

We've got ORA-0942 Table or view not found in our application log. But it does
not tell us which table it is. How do I set up a trace on the database without
having to bounce it. Or do I have to bounce it?

[Jat]

1. To turn on Net tracing on the client:
Add the following parameters to the ORACLE_HOME\network\admin\sqlnet.ora file
TRACE_LEVEL_CLIENT = 16(set this to OFF to turn off tracing)
TRACE_FILE_CLIENT = NetClientTrace
TRACE_DIRECTORY_CLIENT = c:\tmp

2. To turn on Net tracing on the server:
Add the following parameters to the ORACLE_HOME/network/admin/sqlnet.ora file
TRACE_LEVEL_SERVER = 16(set this to OFF to turn off tracing)
TRACE_FILE_SERVER = NetServerTrace
TRACE_DIRECTORY_SERVER = /tmp

3. To turn on SQL tracing in the database:
alter session set events '10046 trace name context forever';
Session level:

alter session set events '10046 trace name context forever';

Init.ora:

event="10046 trace name context forever,level 4"

WARNING: This will trace ALL database sessions

The resulting trace will be placed in the UDUMP area.

Also, to describe the stored procedure in the data dictionary:

SQL> select text from user_source where name like '%%'; (Procedure name needs to be upper case)

SQL> select argument_name, data_type from user_arguments where object_name like '%%';

[joyce_ank]

Thanks

[anandkl]

You can also set the sql trace at session level.
Alter session set sql_trace=true;
On the session for which this error is being generated.

regards
anandkl