sql_trace=true

            timed_statistics=true

            user_dump_dest=/$ORACLE_HOME/rdbms/udump/trc

            max_dump_file_size=1024000

    SQL*PLUS
          timed_statistics = true  initSID.ora
          (V7.3 이상에서는
           SQL> ALTER SESSION SET TIMED_STATISTICS = TRUE;)

          $ sqlplus scott/tiger
 
          SQL> ALTER SESSION SET SQL_TRACE = TRUE;
          SQL> sql문장 실행
          SQL> exit
        

    SQLFORMS30, RUNFORM30 : -s OPTION 사용   
          $ runform30 -s frmfile scott/tiger -c vt220  

    PRO*C
          EXEC SQL CONNECT :username;
          EXEC SQL ALTER SESSION SET SQL_TRACE = TRUE;

         TKPROF trace_file list_file [sort=parameter] [print=number] [explain=username/password]

   예. $ cd $ORACLE_HOME/rdbms/log

        $ tkprof ora_1111 out sort=fchqry,fchcu explain=scott/tiger print=20

**********************************************************************
count   = number of times OCI procedure was executed
cpu     = cpu time in seconds executing
elapsed = elapsed time in seconds executing
disk    = number of physical reads of buffers from disk
query   = number of buffers gotten for consistent read
current = number of buffers gotten in current mode (usually forupdate)
rows    = number of rows processed by the fetch or execute call
**********************************************************************

SELECT COUNT(*)
FROM EMP E, DEPT D
WHERE E.DEPTNO=D.DEPTNO

call    count  cpu    elapsed   disk    query    current    rows
-----------------------------------------------------------------
Parse    2     0.00    0.00       0       0        0         0
Execute  2     0.00    0.00       0       0        0         0
Fetch    2     0.00    0.00       0      33        2         1

Misses in library cache during parse: 1
Parsing user id: 8  (SCOTT)
Rows     Row Source Operation
-------  ---------------------------------------------------
      0  SELECT STATEMENT
      0    SORT (AGGREGATE)
     16      NESTED LOOPS
     16        TABLE ACCESS (FULL) OF 'EMP'
     16        INDEX (UNIQUE SCAN) OF (object id 222584)(UNIQUE)

Rows     Execution Plan
-------  ---------------------------------------------------
      0  SELECT STATEMENT
      0    SORT (AGGREGATE)
     16      NESTED LOOPS
     16        TABLE ACCESS (FULL) OF 'EMP'
     16        INDEX (UNIQUE SCAN) OF 'DEPT_PRIMARY_KEY' (UNIQUE)

*********************************************************************