Re: Automatic recompilations of PLSQL objects

From: Paul Drake <bdbafh_at_gmail.com>
Date: Mon, 3 Oct 2005 11:25:51 -0400
Message-ID: <910046b40510030825l5e3705cche153621e0a8fd656@mail.gmail.com>

On 10/3/05, Gogala, Mladen <MGogala_at_allegientsystems.com> 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_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> 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.

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

Received on Mon Oct 03 2005 - 14:48:10 CDT