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: Isn't PL/SQL Function Result Cache the same as deterministic?

Re: Isn't PL/SQL Function Result Cache the same as deterministic?

From: cleveridea <cleveridea.net_at_gmail.com>
Date: Wed, 26 Sep 2007 22:50:47 -0000
Message-ID: <1190847047.005238.321890@r29g2000hsg.googlegroups.com>


On Sep 26, 3:13 pm, "rogergorden@....gmail.com" <rogergor..._at_gmail.com> wrote:
> I am reading Feuerstein's article in Oracle Magazine and is seems as
> the PL/SQL Function Result Cache is the same as using the
> deterministic keyword.
>
> Is this the case, or am I missing something?
>
> Roger

A deterministic function NEVER involves results from tables. A cached function result takes advantage of cursor results much like the buffer cache, except at a much leaner and meaner granularity. Received on Wed Sep 26 2007 - 17:50:47 CDT

Original text of this message

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