This content has been marked as final. Show 5 replies
Enabling trace facility at SQL prompt
1.DBMS_SESSION set_sql_trace=true (set false after use)
2.alter session set sql_trace=true (set false after use) at session level
3.alter system set sql_trace=true (set false after use) at system level
Then format the trace file with TKPROF
On command promt
TKPROF "\trace.file" "location file"