Xref: alice comp.databases.oracle.server:46392
Path: alice!news-feed.fnsi.net!news.idt.net!dispose.news.demon.net!demon!bullseye.news.demon.net!demon!news.demon.nl!demon!sybrandb.demon.nl!not-for-mail
From: "Sybrand Bakker" <postbus@sybrandb.demon.nl>
Newsgroups: comp.databases.oracle.server
Subject: Re: **Performance of queries
Date: Tue, 20 Apr 1999 06:34:14 +0200
Organization: Bentley Systems Europe
Message-ID: <924582996.5679.0.muttley.d4ee154e@news.demon.nl>
References: <7fgnqa$b8c$3@bgtnsc02.worldnet.att.net>
X-Trace: news.demon.nl 924582996 muttley:5679 NO-IDENT sybrandb.demon.nl:212.238.21.78
X-Complaints-To: abuse@demon.net
X-Newsreader: Microsoft Outlook Express 4.72.3110.5
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Lines: 38

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@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@worldnet.att.net
>
>
>