Tkprof for Databse

Commands to obtain Tkprof for a package

Type the following commands in SQL to obtain the tkprof.

---------------------------------------------------------------------------------------------------------

SQL> alter session set tracefile_identifier = SQL_Trace;

Session altered.

SQL> alter session set sql_trace=true;

Session altered.

SQL> begin

  pkg_name.proc_name (‘input values’);

  end;

  /

PL/SQL procedure successfully completed.

SQL> alter session set sql_trace=false;

Session altered.

SQL> EXIT;

-----------------------------------------------------------------------------------------------------------