Re: Automatic recompilations of PLSQL objects
- From: Paul Drake <bdbafh@xxxxxxxxx>
- To: rjamya@xxxxxxxxx
- Date: Mon, 3 Oct 2005 11:00:15 -0400
On 10/3/05, rjamya <rjamya@xxxxxxxxx> 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
Other related posts:
