Pinning Objects in the memory.

[tekpr00]

Hello All,

I will like to pin table and its indexes to memory as recommended by Software vendor.

Could you advice on the best method as I am getting errors as follows.
exec DBMS_SHARED_POOL.KEEP('EMPIADMIN.MPI_AHEAD') --this is for a table.
ERROR at line 1:
ORA-04047: object specified is incompatible with the flag specified
ORA-06512: at "SYS.DBMS_UTILITY", line 155
ORA-06512: at "SYS.DBMS_SHARED_POOL", line 55
ORA-06512: at "SYS.DBMS_SHARED_POOL", line 67
ORA-06512: at line 1

So I inseted a flag:
SQL> exec DBMS_SHARED_POOL.KEEP('EMPIADMIN.MPI_AHEAD', 'T');
BEGIN DBMS_SHARED_POOL.KEEP('EMPIADMIN.MPI_AHEAD', 'T'); END;

*
ERROR at line 1:
ORA-04047: object specified is incompatible with the flag specified
ORA-06512: at "SYS.DBMS_UTILITY", line 155
ORA-06512: at "SYS.DBMS_SHARED_POOL", line 55
ORA-06512: at "SYS.DBMS_SHARED_POOL", line 67
ORA-06512: at line 1

Pleas let me know of a command that I can use for pinning tables and indexes.

Thank You.

 

[yelworcm]

The shared pool is for Library cache items. You want to alter the table's storage parameters. Look up ALTER TABLE. I believe it is in the storage clause.

 

[tekpr00]

Thanks,
I finally used:
alter table MPI_AHEAD storage (buffer_pool default);
before seeing your reply.
Thanks