Re: Oracle 10g invalid system packages

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: 27 Sep 2005 12:11:29 -0700
Message-ID: <1127848289.268776.191280@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? Received on Tue Sep 27 2005 - 14:11:29 CDT