如何将小表放入keep池中

大菠萝

如上

大菠萝

我自己顶

yikaikai

倒      不知道就不要乱说

yikaikai

看看DBMS_SHARED_POOL PACKAGE 的用法

yikaikai

KEEP Procedure
This procedure keeps an object in the shared pool. Once an object has been kept in
the shared pool, it is not subject to aging out of the pool. This may be useful for
frequently used large objects. When large objects are brought into the shared pool,
several objects may need to be aged out to create a contiguous area large enough.
Syntax
DBMS_SHARED_POOL.KEEP (
name VARCHAR2,
flag CHAR DEFAULT ’P’);

yufeng8552

能否讲完全些呢

大菠萝

KEEP Procedure
This procedure keeps an object in the shared pool. Once an object has been kept in
the shared pool, it is not subject to aging out of the pool. This may be useful for
frequently used large objects. When large objects are brought into the shared pool,
several objects may need to be aged out to create a contiguous area large enough.
Syntax
DBMS_SHARED_POOL.KEEP (
name VARCHAR2,
flag CHAR DEFAULT ’P’);

这段话,我倒是看过,可是有问题
我用DBMS_SHARED_POOL.KEEP(...),SQL*plus说找不到,不知道是什么原因

大哥,能给我一段测试代码吗?将一个指定的表,插入一些数据,放入keep池中,读取数据

1. 
   
2. create table testKeep(OID number);
   
3. begin
   
4. insert into testKeep(OID) values(1);
   
5. insert into testKeep(OID) values(2);
   
6. insert into testKeep(OID) values(3);
   
7. insert into testKeep(OID) values(4);
   
8. insert into testKeep(OID) values(5);
   
9. end;
   

复制代码

如何放入keep池中了??

txfy

alter table xxx storage(buffer_pool_keep):

大菠萝

alter table xxx storage(buffer_pool_keep);

我搞懂了,谢谢txfy

不过,好像是alter table xxx storage(buffer_pool keep);