You will not see all objects valid + enabled all the time - database schema
changes, startup/shutdown , etc will invalidate objects - invalid does not
mean incorrect necessarily just invalidated or not validated (word smiting)
- here is a script to run that will create a script that you can then run to
compile all invalid objects in the database - you might have to slightly
modify the script depending on the version of oracle you are running - enjoy
and take care



Tim Angel
Telephone: 870.541.3902
Internal: 8.760.3902
Email: [Email Address Removed] Message-----
From: Mitchell Baldwin [mailto:mitchell.[Email Address Removed] Thursday, January 31, 2002 10:11 AM
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