lunes, 25 de enero de 2021

trcsess and tkprof.

 trcsess output=orcl_trace.txt service=orcl orcl_ora_4143.trc orcl_ora_4186.trc orcl_ora_4196.trc

$ tkprof orcl_trace.trc resultado.txt sys=no

$ tkprof orcl_trace.trc resultado.txt sys=no sort=execpu

tkprof orcl_trace.trc resultado.txt sys=no sort=exeela

tkprof orcl_ora_4196.trc resultado.txt sys=no

ACTIVAR TRACE 

EXEC  DBMS_MONITOR.session_trace_enable(waits=>TRUE, binds=>TRUE);
EXEC  DBMS_MONITOR.session_trace_disable;

VISTA VER TRACES DBA_EANBLED_TRACES


No hay comentarios: