Re: compiled/valid or not compiled... that is the question
- From: Juan Carlos Reyes Pacheco <jcdrpllist@xxxxxxxxx>
- To: Patrice sur GMail <patrice.boivin@xxxxxxxxx>
- Date: Wed, 3 Sep 2014 11:00:29 -0400
I think is faster to decompile and recompile. :)
But I don't see too tragic, the only problem is when you make an upgrade to
your database and a customer run the function and give an error the last
moment, otherwise it has some benefits.
2014-08-28 11:17 GMT-04:00 Patrice sur GMail <patrice.boivin@xxxxxxxxx>:
> I did a crazy thing, hoping it worked... I ran a script throughout a
> weekend which did a select count(1) on every table, view, mview in the
> database. Took over 3 days to finish. couldn't shut down and restart the
> instance so I thought that might help me a bit get some truth from that
> bad, dishonest, lying data dictionary... ^_^
>
>
> On Wed, Aug 27, 2014 at 8:29 PM, Juan Carlos Reyes Pacheco <
> jcdrpllist@xxxxxxxxx> wrote:
>
>> 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@xxxxxxxxx>:
>>
>> 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>
>>>
>>
>>
>
>
> --
>
>
> -- 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>
>
Other related posts:
