Re: SQL statistics
From: Murali Kazhipurath <murali_at_jps.net>
Date: 1996/12/02
Message-ID: <01bbdffd$40c6a220$65646464_at_licorice>#1/1
Date: 1996/12/02
Message-ID: <01bbdffd$40c6a220$65646464_at_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>...Received on Mon Dec 02 1996 - 00:00:00 CET
> 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
>
>
>