Re: Automatic recompilations of PLSQL objects

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

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