Alter system enable session trace

exec dbms_system.set_sql_trace_in_session(130 /* sid */,9 /* serial# */,true);
exec dbms_system.set_sql_trace_in_session(451 /* sid */,3 /* serial# */,true);
exec dbms_system.set_sql_trace_in_session(642 /* sid */,17 /* serial# */,true);

 

exec dbms_system.set_sql_trace_in_session(130 /* sid */,9 /* serial# */,false);
exec dbms_system.set_sql_trace_in_session(451 /* sid */,3 /* serial# */,false);
exec dbms_system.set_sql_trace_in_session(642 /* sid */,17 /* serial# */,false);

 

 
TKPROF tracefile.trc ora_trans_file_name.prf SORT = (PRSDSK, EXEDSK, FCHDSK) PRINT = 10

 

Leave a Reply

Your email address will not be published. Required fields are marked *