Re: TKPROF does it work, and if so, HOW?!
From: Ari Likki <likkiar1_at_news.ougf.fi>
Date: 29 Sep 1994 22:53:19 -0100
Message-ID: <36fk1fINN4g5_at_news.ougf.fi>
Date: 29 Sep 1994 22:53:19 -0100
Message-ID: <36fk1fINN4g5_at_news.ougf.fi>
If you are using SQL*Plus, use command
SQL> set timing on
and then submit your transaction. SQL*Plus will tell you the total elapsed time.
TKPROF is good for example finding out how your select statement works
TKPROF nnn.nnn EXPLAIN=UN/PW
where nnn.nnn is the trace file name
UN is then table owner and PW the password
About those timings you get with TKPROF, I don't know. Sorry.
Regards
Ari Likki
Yhtyneet Kuvalehdet Oy/United Magazines Ltd
Helsinki, Finland
Received on Fri Sep 30 1994 - 00:53:19 CET