Yes... And I Answered That As My First Word In My previous Mail ....
When The triggers call the procs... Then Automatic recompilitaion will take
place...
But pls be aware of this.
If Proc A Calls Proc B and and B calls C and C Calls A Then it will Fail...
HTH
Best Regards,
Ganesh R
Tel : +971 (4) 397 3337 Ext 420
Fax : +971 (4) 397 6262
HP : +971 (50) 7456019
-----Original Message-----
From: Mitchell Baldwin [mailto:mitchell.[Email Address Removed] Thursday, January 31, 2002 8:41 PM
To: Ganesh Raja <ganesh
Cc: LazyDBA.com Discussion
Subject: RE: Compilation on execution ?
I know how to compile the schemas etc, but I was querying the concepts of
re compilation on execution !
The triggers call procedures which are also invalid, and I was questioning
whether an implicit compilation of the procedure will be activated when the
invalid trigger fires.
Ganesh Raja
<[Email Address Removed] To: "LazyDBA.com
Discussion" <[Email Address Removed]
.com> cc:
Subject: RE: Compilation on
execution ?
31/01/02 16:32
Surely This is a Overhead ...
U can check the %ORACLE_HOME%/RDBMS/ADMIN Directory for utlrcmp.sql.... And
Recompile all the Invalid Objects in your Schema....
HTH
Best Regards,
Ganesh R
Tel : +971 (4) 397 3337 Ext 420
Fax : +971 (4) 397 6262
HP : +971 (50) 7456019
-----Original Message-----
From: Mitchell Baldwin [mailto:mitchell.[Email Address Removed] Thursday, January 31, 2002 8:11 PM
To: LazyDBA.com Discussion
Subject: Compilation on execution ?
Hi
I'm supporting an application, that as part of the overnight batch run
triggers + procedures become invalid. (350 + objects)
Now the consultants implementing the system say that's fine as the trigger
and subsequent procedures will be compiled on next execution.
Surely this is an overhead on transaction time, further more I'm concerned
about this and would like to see all objects valid + enabled all the time.
Any thoughts or experience's anyone ?
TIA
Mitch
--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html
--------
Oracle documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these terms:
http://www.lazydba.com/legal.html
Oracle LazyDBA home page