Originally Posted by
LKBrwn_DBA
Are you sure the query you want to trace is being executed in the session you are tracing? Does not seem it is.
It should......
this is what I do
get the sid /serial# of the connected user from v$session
as DBA set parameters
SQL> exec sys.dbms_system.set_sql_trace_in_session(67,21397,true); ---params from above
PL/SQL procedure successfully completed.
executed a sql from the session/sid/serial# above
then turn off tracing
SQL> exec sys.dbms_system.set_sql_trace_in_session(67,21397,false);
PL/SQL procedure successfully completed.
Is there something missing? when I then do the TKprof?
Looking for the greatest evil in the world? Look in the mirror.
Reply With Quote