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 LazyDBA home page