Re: Dependencies and invalidations.

From: Vladimir M. Zakharychev <vladimir.zakharychev_at_gmail.com>
Date: 24 Apr 2006 13:12:55 -0700
Message-ID: <1145909574.737288.217950@v46g2000cwv.googlegroups.com>

Mladen Gogala wrote:
> On Sun, 23 Apr 2006 22:24:33 -0700, Vladimir M. Zakharychev wrote:
>
> > Well, not always. It's dynamically parsed on every invocation for
> > invoker rights PL/SQL only.
>
> So, what happens when circumstances force SQL execution plan change?
>

SQL runs under the new plan. PL/SQL is not invalidated though, because syntactically and semantically your static SQL didn't change and that's all PL/SQL engine cares about. Dynamic SQL has to be parsed every time anyway - because it's dynamic and can change between execute calls - but if it can be soft-parsed, it is, so it may not pick up the new plan until it's aged out of the shared pool and then reloaded.

Corrections and additions welcome.

Regards,

Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm) http://www.dynamicpsp.com Received on Mon Apr 24 2006 - 15:12:55 CDT