Re: compiled/valid or not compiled... that is the question

From: Juan Carlos Reyes Pacheco <jcdrpllist_at_gmail.com>
Date: Wed, 27 Aug 2014 19:29:05 -0400
Message-ID: <CAGYrQyvi9QBYaTm1s1AJcOrwbTfrx6JEkRHC4FT=TvtaR_GKfQ_at_mail.gmail.com>

I'I remember there was an improvement of 11g on recompilation, taht optimized teh process, I had that problem too, i suppose is a bug because decompiles some and not others, but I think there is an improvement anyway, because had reduced the decompilation of procedures.

does running execute utl_recomp.recomp_serial(); solve the problem?

2014-08-20 14:43 GMT-04:00 Patrice sur GMail <patrice.boivin_at_gmail.com>:

> It's fun that in the data dictionary, objects can be listed as "valid"
> even though their underlying components may have disappeared or db links
> stopped working properly.
>
> The server never double checks, it assumes they ave valid until someone
> tries to use the object or the database is restarted.
>
> So the information in the data dictionary is not necessarily trustworthy.
>
> -- Patrice
> My profiles: [image: Facebook]
> <http://www.facebook.com/home.php?#!/profile.php?id=100000206805521>[image:
> LinkedIn] <http://ca.linkedin.com/pub/patrice-boivin/a/933/5a9>[image:
> Twitter] <http://www.twitter.com/PatriceBoivin>
> <http://www.twitter.com/PatriceBoivin>
> Signature powered by WiseStamp <http://www.wisestamp.com/email-install>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Aug 28 2014 - 01:29:05 CEST