Re: Top Session BIG problem

From: (wrong string) öström <lasse.sjostrom_at_telia.com>
Date: Thu, 21 Oct 1999 17:47:08 GMT
Message-ID: <wkIP3.144$9C1.1548_at_newsc.telia.net>


To get an EXPLAIN PLAN you need two things. The PLAN_TABLE (can be created by a script included in the distribution) and when you issue the SQL-statement you need to do something special

EXPLAIN PLAN SET STATEMENT ID= i believe it is. Also certainly shown in the doc.

Lars S
Sweden

Tomasz Fidecki skrev i meddelandet <380F2887.308888FB_at_jms.com.pl>...
>Hi
>
>I'm new with oracle.
>I have problem with watching query Explain Plan under Top Session Window
>(oracle 8.0.5).
>I choose session and details->cursors. Next I choose cursor and finally
>->show explain plan. Always I'm getting following error:
>
>"ORA 01403 No Data found"
>
>Any suggestions?
>
>--
>Tomasz Fidecki
>JMS Serwis Sp. z o.o. ul. Instalatorów 7c 02-237 Warsaw Poland
>phone +48 22 846 47 81 mobile +48 501 136 122 mailto:tfidecki_at_jms.com.pl
Received on Thu Oct 21 1999 - 19:47:08 CEST

Original text of this message