RE: Automatic recompilations of PLSQL objects
- From: "Gogala, Mladen" <MGogala@xxxxxxxxxxxxxxxxxxxx>
- To: "'bdbafh@xxxxxxxxx'" <bdbafh@xxxxxxxxx>
- Date: Mon, 3 Oct 2005 11:13:02 -0400
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@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 <mailto: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:
