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:
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.