Cannot pin a procedure in shared pool
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Cannot pin a procedure in shared pool

  1. #1
    Join Date
    Sep 2003
    Location
    China
    Posts
    72

    Cannot pin a procedure in shared pool

    A procedure, populate, is of frequent use and I want it to be pinned in shared pool. Here is what I did.

    I have execute @d:\oracle\rdbms\admin\dbmspool.sql in production user but with 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.


    Then I login to sys and run the dbmspool.sql again and this time no error. Then I 'exec dbms_shared_pool.keep('POPULATE');' Successful but when I check 'select * from v$db_object_cache where name = 'POPULATE'' The kept is still 'no' This procedure is still not pinned. Why? Also how to pin objects in production user not 'sys'. Tks.

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    how about read dbmspool.sql

  3. #3
    Join Date
    Oct 2002
    Location
    CA
    Posts
    67

    Smile

    Make sure you have select on privilege on that table.

    You can run grant select on xxxx to userXXX;
    --------------------------------------
    It's not what the world does to you that matters. It's how you respond...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width