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

From: Patrice sur GMail <patrice.boivin_at_gmail.com>
Date: Thu, 28 Aug 2014 12:17:16 -0300
Message-ID: <CACH2EDL0QN6D01xOfJjgy7LSEpdd09SpUhftp2NDb=M+Q=aVqQ_at_mail.gmail.com>

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_at_gmail.com> 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_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>
>>
>
>

-- 


-- 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 - 17:17:16 CEST