Next time, I should remember to check with Tom first before firing
away. Metalink seems chock-full of these reports as well. Thanks for
the info, Michael! =)
"Michel Cadot" <micadot{at}altern{dot}org> wrote in message news:<413353e6$0$17096$626a14ce_at_news.free.fr>...
> "Romeo Olympia" <rolympia_at_hotmail.com> a écrit dans le message de
> news:42fc55dc.0408300650.765bfa39_at_posting.google.com...
> > What kind of functions do you have? Do their results depend solely on
> > the input parameters and not on any session variables or database
> > objects which might change in between calls?
> >
> > If yes, then you could also try declaring your functions as
> > DETERMINISTIC. If this is feasible, then Oracle does not re-execute
> > the same function with the same parameters within the same statement.
> >
> > See the PL/SQL manual for details on this. HTH.
>
> Using deterministic or not is not relevant for this case.
> The number of times the function is called is not dependant on this parameter.
> It depends only on the execution plan.
>
> Have a look at this tread on Ask Tom's site:
> http://asktom.oracle.com/pls/ask/f?p=4950:8:3809045269958567894::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:3575529924010,
Received on Mon Aug 30 2004 - 20:38:21 CDT
