Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle/SQL Question
There is a simple way to get "EXPLAIN PLAN" results... if you are using
SQL*PLUS 3.3, you just type SET AUTOTRACE ON, the you enter the SQL
statement and voila...
Steve Cosner wrote in message <6gvue0$jqr2_at_hendrix.csufresno.edu>...
>efficient and all I need. I also have an "Explain Plan" script that I
>run with the command @Explain which gives me all the information I
>need. (I'll pass along the script if anyone wants it.)
>
>To get an explain plan, all I do is type: EXPLAIN PLAN FOR on a
>separate line, then swap over to the editor and copy the select I want
>to try, swap back to SQL Plus, and paste (with Shift-Insert) the text
>of the select. Follow that with @EXPLAIN, and it's done.
>
>If you have a system that can "take forever" when you use the wrong
>select or index, you should develop a smaller test database to try
>your work on first. Also, do an explain plan on anything you are
>unsure about before you really execute it on your large database. As
>for killing the application, your orphan session should go away after
>a while automatically.
>
>Regards,
>Steve Cosner
>http://members.aol.com/stevec5088
>
Received on Fri Apr 17 1998 - 10:09:17 CDT