On 10/3/05, Gogala, Mladen <MGogala@xxxxxxxxxxxxxxxxxxxx> wrote: > > 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 > Mladen, Ah yes, now that the caffeine is kicking in - I'm recalling that 10520 was to skip dependency checking during a dictionary upgrade. It assumed that utlrp would be run afterwards. This probably isn't the droid that Raj was looking for. Paul ------------------------------ > > *From:* Paul Drake [mailto:bdbafh@xxxxxxxxx] > *Sent:* Monday, October 03, 2005 11:00 AM > *To:* rjamya@xxxxxxxxx > *Cc:* Oracle Discussion List > *Subject:* Re: Automatic recompilations of PLSQL objects > > 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 > -- #/etc/init.d/init.cssd stop # f=ma, divide by 1, convert to moles.