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
