Re: Oracle 10g invalid system packages

From: Matthias Hoys <idmwarpzone_NOSPAM__at_yahoo.com>
Date: Tue, 27 Sep 2005 22:47:16 +0200
Message-ID: <4339afd3$0$14828$ba620e4c@news.skynet.be>

"hpuxrac" <johnbhurley_at_sbcglobal.net> wrote in message news:1127848289.268776.191280_at_g43g2000cwa.googlegroups.com...
> Matthias Hoys wrote:
>> Oracle 10.1.0.4.0 on AIX 5.2.
>>
>> I noticed that some system pl/sql packages become invalid after a certain
>> period of time, for example sys.dbms_sqltune. However, after manual
>> recompilation, everything becomes valid again (without errors). Is this a
>> bug ? Is my shared pool maybe too small ?
>>
>> Matthias
>
> Should we guess at what your shared pool is sized at? Do you configure
> it manually or have oracle size it?
>
> Did you look at metalink?
>

Not enough time yet to look on metalink, will check on asktom thanks. Received on Tue Sep 27 2005 - 15:47:16 CDT