Re: compiled/valid or not compiled... that is the question
- From: Patrice sur GMail <patrice.boivin@xxxxxxxxx>
- To: Juan Carlos Reyes Pacheco <jcdrpllist@xxxxxxxxx>
- Date: Thu, 28 Aug 2014 12:17:16 -0300
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:
