Re: Automatic recompilations of PLSQL objects

Thanks Paul,

I looked up, it says "don't compile unless the definition has changed". What's happening in our case is that developer is making two changes to a heavily referenced table. I'l like to indicate to Oracle to wait recompilations until the script is complete.

I'll look further into it.

Raj

On 10/3/05, Paul Drake <bdbafh_at_gmail.com> wrote:
>
> On 10/3/05, rjamya <rjamya_at_gmail.com> wrote:
> >
> > Is there a flag, setting that we can set in a session to tell Oracle "do
> > not recompile" invalidates objects until the end of script ?? DB is 9204.
> >
> > TIA
> > Raj
> > ------------------------------
> > select standard_disclaimer from company_requirements where category =
> > 'MANDATORY';
> >
>
> Raj,
>
> Way back in the days before catpatch.sql was available, the patchset
> readme's included this:
>
> ALTER SESSION SET EVENTS '10520 TRACE NAME CONTEXT FOREVER, LEVEL 10';
>
> hth.
>
> Paul
>
>

--
------------------------------
select standard_disclaimer from company_requirements where category =
'MANDATORY';

--
http://www.freelists.org/webpage/oracle-l