Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Getting detailed informations of a sql-statement

Re: Getting detailed informations of a sql-statement

From: Alan D. Mills <alanmNOSPAM_at_uk.europe.mcd.mot.com>
Date: Thu, 15 Oct 1998 14:12:33 +0100
Message-ID: <704sar$cgs$1@schbbs.mot.com>


You need to use Oracle EXPLAIN PLAN functionality. I suggest you use the EXPLAIN PLAN part of TOAD.

--
Alan D. Mills

agrudzinski_at_cs-controlling.de wrote in message <704jse$es7$1_at_nnrp1.dejanews.com>...
>Hi,
>Which possibilities do I have to analyze
>bad performance?
>
>Thanks in advance,
>
>Astrid Grudzinski
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Thu Oct 15 1998 - 08:12:33 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US