Any ideas how to load static data tables into memory.
I'm under the impression that dbms_shared_pool.keep is for packages and procedures only?
Printable View
Any ideas how to load static data tables into memory.
I'm under the impression that dbms_shared_pool.keep is for packages and procedures only?
pls use the keep option while creating the table.
Rgds
Ganesh .R
alter table table_name cache;
Before pinning any table in buffer do a analyze table .see that the number of free blocks.See to it that they are as much as low as possible.if the free blocks are more use the alter table move command and recreate the table till you get the desired levels .
then do pinning of the objects (tables)in memory.Inthis manner your will use the resourese in a proper manner.
thanks for the input