Re: **Performance of queries

Hi Haruka,

Two methods to do this:
in sqlplus 3.3 and beyond
use :
set autotrace on explain stat
This will dump tkprof like results to output after completion of a query. You need create table privilege (and you may need -I'm not sure- to create the plan table manually. The script is in $ORACLE_HOME/rdbms/admin/utlxplan for Unix and %ORACLE_HOME%\rdbms<nn>\admin\utlxplan, where nn is either 73 or 80 depending on version of rdbms)
second method
use tkprof
generally:
tkprof(<nn> if on NT) <name of trace file> <output file> explain=<username/password of the user running the query) If you want timings the init<sid>.ora parameter timed_statistics should be true.
Hth,
Sybrand Bakker, Oracle DBA

Haruka Suko wrote in message <7fgnqa$b8c$3_at_bgtnsc02.worldnet.att.net>...
>Hello!
>I would like to know the performance of the query(how fast the query was
>executed, etc).
>Do I need to use tkprof? If anyone can tell me how to use it, I really
>appreciate it.
>Or, is there any way to measure the performance of the query without
tkprof?
>Thank you so much!
>
>Haruka Suko
>haruka-suko_at_worldnet.att.net
>
>
>
Received on Mon Apr 19 1999 - 23:34:14 CDT