RE: Automatic recompilations of PLSQL objects

Hmmm, for the given event level 10 is awfully strange, knowing that oraus.msg says the following:  

10520, 00000, "recreate package/procedure/view only if definition has changed"

// *Cause:

// *Action: Set this event only under the supervision of Oracle development

// *Comment: Changes behaviour of create or replace package|procedure|view,

// comparing the new definition to the old prior to recreating the

// object. Creation is skipped if old and new definitions match

// (ie. object has not changed). No level number required.    

I believe that one of these two sources is wrong and there is only one exact way to determine which

one is wrong: eeney, meeney, miney, moe, catch your event by its toe.  

--

Mladen Gogala

Ext. 121

  _____  

From: Paul Drake [mailto:bdbafh_at_gmail.com] 
Sent: Monday, October 03, 2005 11:00 AM
To: rjamya_at_gmail.com
Cc: Oracle Discussion List
Subject: Re: Automatic recompilations of PLSQL objects

 

On 10/3/05, rjamya <rjamya_at_gmail.com <mailto: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