Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: DBMS_SHARED_POOL problem

Re: DBMS_SHARED_POOL problem

From: Darin Nielsen <darin_at_cis.com>
Date: Wed, 23 Sep 1998 16:34:14 GMT
Message-ID: <360922e4.514727659@news.inconnect.com>


On Wed, 23 Sep 1998 16:23:49 GMT, darin_at_cis.com (Darin Nielsen) wrote:

        Sorry, I didn't see that you had already created it.

>you have to run $ORACLE_HOME/rdbms/dbmspool.sql to
>create the package dbms_shared_pool
><Darin Nielsen, darin_at_cis.com>
>
>
>
>On 16 Sep 1998 12:28:34 GMT, "Leon van der Zanden"
><l.van.der.zanden_at_epz.nl> wrote:
>
>>Do you have execute-rights?
>>What if you use SQL> exec sys.dbms_sharedpool.sizes(10)?
>>
>>
>>Vaughan Mc Carthy <vaughanm_at_medscheme.co.za> schreef in artikel
>><6to9vr$m4p$1_at_hermes.is.co.za>...
>>> Hi there
>>>
>>> I have the following error messages, when I try to execute the
>>> DBMS_SHARED_POOL package. I have already created the package as SYS and
>>it
>>> is valid - even after I try to execute it.
>>>
>>
>
Received on Wed Sep 23 1998 - 11:34:14 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US