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

Home -> Community -> Usenet -> c.d.o.server -> Re: newbie, getting cost plan

Re: newbie, getting cost plan

From: Jan Krueger <jk_at_stud.uni-hannover.de>
Date: Sun, 09 Sep 2007 19:21:20 +0200
Message-ID: <46e42b05$0$29371$4c56b896@news-read1.lambdanet.net>


codefragment_at_googlemail.com wrote:
> One way I've seen is to get the address of the last statement issued
> using this:
>
> select sql_text, address, FIRST_LOAD_TIME from v$sql order by
> FIRST_LOAD_TIME asc;
>
> then with that address run a script on v$sql_plan to put the info in
> the plan_table. For ease when when testing stored procedures I put
> them in a file and just call @callsp, they don't appear in the v$sql
> view though? Anything I
> can do with this? Looks like an easy way of getting the info I want
>
> (script on http://www.oracleadvice.com/Tips/plantip.htm)
>
> thanks for the replies
>
>

Maybe there is something left to mention. An execution plan never shows "real cost". It only show the cost the CBO has made assuptions about before the statement was executed.

Jan Received on Sun Sep 09 2007 - 12:21:20 CDT

Original text of this message

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