Sponsored Links
how to use tkprof
alter system set sql_trace=true scope=memory;
Run SQLs to trace
alter system set sql_trace=false scope=memory;
Move trc to separate folder
C:\oracle\product\10.2.0\admin\db\udump\>
trcsess output=output.trc service=DBSID *trc
--trcsess merge all trace files
C:\oracle\product\10.2.0\admin\db\udump\>
tkprof output.trc output.txt explain=abc/abc@dbst
Page 1
|
| 
