Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Invalid objects
Margaret -
The quick answer is LOTS OF THINGS! :-) The important part is
there is extremely little impact on the applicatoin.
When the app accesses an invalid object it will re-compile it
automaticallly. As long as it re-compiles successfully there
is only a small performance issues while the re-compile takes
place.
What causes it to be invalid - something changed. for instance
- Procedure A accesses view G. View G changes which
invalidates Procedure A.
There are views/tables that provide dependance information
which can be very valuable in figuring out what affect
changeing an object will have.
See USER_DEPENDENCIES and script UTLDTREE.SQL found in
rdbms/admin. The script creates several nice objects - my
favorite is ideptree which is an indented list.
Becca
>
> If Iperform the query
>
> select owner||'.'||object_name, object_type from dba_objects
> where status = 'INVALID';
>
> I find a number of procedures, packages, package bodies and
views are
> listed.
>
> What would cause an object to become invalid and what are the
implcations
> for the application?
>
> Margaret
>
>
--
This answer is courtesy of QuestionExchange.com
http://www.questionexchange.com/showUsenetGuest.jhtml?ans_id=6332&cus_id=USENET&qtn_id=6321
Received on Mon Oct 25 1999 - 21:00:10 CDT