Re: SQL statistics

From: Murali Kazhipurath <murali_at_jps.net>
Date: 1996/12/02
Message-ID: <01bbdffd$40c6a220$65646464@licorice>#1/1

To display the query plan, use EXPLAIN PLAN.

To display query statistics execute :

alter session set SQL_TRACE=TRUE;
execute your query
alter session set SQL_TRACE=FALSE;

Use Tkprof73 to format the trace output. Check the manual for more information.

I specialize in fine tuning applications. Feel free to contact me if you need more help.

Murali

-- 
Murali Kazhipurath
Technical Consultant
Kaustubam (Database and Internet Solutions Provider)
murali_at_jps.net
Phone # (916) 773 1918

Zernan Martinez <zlm101_at_psu.edu> wrote in article <32a1d459.203081_at_news>...


> Does anybody know how to display statistics on a SQL request?

> I would like to know how Oracle processed my query any hopefully be

> able to optimize my request.

> 

> Thanks for any info.

> 

> Please respond to zlm101_at_psu.edu

> 

> 

>

Received on Mon Dec 02 1996 - 00:00:00 CST