Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Oracle Trace
- Thread starter varajan
- Start date
Yes, you can do it for one session like this:
dbms_system.set_sql_trace_in_session(SID,SerialNb,true);
where you may find SID and SerialNB in v$session:
SELECT SID, SERIAL# SerialNb FROM v$session;
And you also can do it for all sessions like this (under SYS):
alter system set events '10046 trace name context forever, level 4'
and then you can disable the traces with the folloowing command:
alter system set events '10046 trace name context off'
You will find the trace files in the $ORACLE_BASE/admin/$ORACLE_SID/udump directory (this settings could be changed in the init.ora file).
Greetings,
Alain
dbms_system.set_sql_trace_in_session(SID,SerialNb,true);
where you may find SID and SerialNB in v$session:
SELECT SID, SERIAL# SerialNb FROM v$session;
And you also can do it for all sessions like this (under SYS):
alter system set events '10046 trace name context forever, level 4'
and then you can disable the traces with the folloowing command:
alter system set events '10046 trace name context off'
You will find the trace files in the $ORACLE_BASE/admin/$ORACLE_SID/udump directory (this settings could be changed in the init.ora file).
Greetings,
Alain
- Status
Similar threads
- Locked
- Question