How to trace PL/SQL Package?How to trace PL/SQL procedures?How to trace SQL statement?what is DBMS_TRACE? How to use?SET AUTOTRACE ON; ?If anyone tell me how we can use trace and create log that would be great?

Interview Candidate
Jul 21st, 2006
2
7264

Showing Answers 1 - 2 of 2 Answers

Jian Zhang

Oct 10th, 2006

When you want to see the execute plan of a SQL statement, you need to use TRACE function of Oracle.

sunflower

Feb 22nd, 2007

DBMS_TRACE package can be used to keep track of the calls between the subprograms and trace of execution by sub-program, procedures, functions or an exception. It gives a large amount of trace data. To make this particular trace data more readable. TKPROF tool , is used to make the trace data in a report format.
A typical session involves:
Starting PL/SQL tracing in session (DBMS_TRACE.SET_PLSQL_TRACE).
Running an application to be traced.
Stopping PL/SQL tracing in session (DBMS_TRACE.CLEAR_PLSQL_TRACE).