设置表在缓冲池保持buffer cache (keep cache)

---将表SCOTT用户下的emp表的放到keep池
SQL>alter table scott.emp storage(buffer_pool keep);
SQL> select segment_name,buffer_pool from dba_segments where buffer_pool = 'KEEP';

---将表放回默认池
SQL>alter table scott.emp storage(buffer_pool  default);
SQL> select segment_name,buffer_pool from dba_segments
where   segment_name='EMP';

SEGMENT_NAME                                                                   
----------------------------
BUFFER_                                                                        
-------                                                                        
EMP                                                                            
DEFAULT    
 

转载于:https://blog.51cto.com/yeluyide/1135475