Re: DBMS_SHARED_POOL.KEEP Question

There could be two reasons for this to be happening. 1) the size of your shared pool is too small for you to keep everything you want in there. Your shared pool should be at least 20M depending on what you are doing. But keep in mind that a 100M shared pool is also a good size. 2) The object dba_object_size is invalid probably becuase a dependent object is invalid. do a "show errors sys.dba_object_size" to see exactly why it compiled with errors.

Shawn

kush wrote:
>
> Hi all, I am trying to use DBMS_SHARED_POOL.KEEP package to keep some of
> pl/sql objects. for this I tried to run dbmspool.sql, but it gave me
> follwing error
> Package created.
> Grant succeeded.
> from dba_object_size
> *
> ERROR at line 4:
> ORA-00942: table or view does not exist
> Warning: Package Body created with compilation errors.
>
> After getting this, looked to me that package is created, I tried to use
> DBMS_SHARED_POOL.KEEP but gave me this error
> ERROR at line 1:
> ORA-04068: existing state of packages has been discarded
> ORA-04063: package body "SA.DBMS_SHARED_POOL" has errors
> ORA-06508: PL/SQL: could not find program unit being called
> ORA-06512: at line 1
>
> Any ideas? do I need to run any other .sql before running dbmspool.sql, if
> not why I was getting compilation error and what is the solution?
> Thanks in advance.
>
> kush
Received on Tue Dec 19 2000 - 20:13:14 CST