Running TKPROF

• Program executes in a DOS box

• Example using explain option and storing output in a .PRF file

  • tkprof8x ora00333.trc ora00333.prf explain = user/password

• Output example (some of it)

• call count cpu elapsed disk query current rows

• ---- ------- ------- --------- -------- -------- ------- ------

• Parse 1 0.16 0.29 3 13 0 0

• Execute 1 0.00 0.00 0 0 0 0

• Fetch 1 0.03 0.26 2 2 4 14

• Output may be stored in the database, see ORA DOC

Notes: