第62次：2014-11-28

botang

1. select  * from v$sgastat;
   
2. 
   
3. select * from v$rowcache;
   
4. 
   
5. select * from v$librarycache;
   
6. 
   
7. select  t.buffer_pool  from dba_Tables t where t.owner='HR' and t.table_name='EMPLOYEES';
   
8. 
   
9. alter table hr.employees storage ( buffer_pool  keep);
   
10. 
    
11. select  * from dba_source s where s.owner='HR' and s.name='ADD_JOB_HISTORY';
    
12. 
    
13. select * from dba_objects o where o.owner='HR' ;
    
14. 
    
15. select  job_id  from hr.employees where   department_id=10;
    
16. 
    
17. 
    
18. select  * from v_$db_object_cache   doc where doc.name='ADD_JOB_HISTORY'  ;
    
19. 
    
20. begin
    
21.    dbms_shared_pool.keep('HR.ADD_JOB_HISTORY');
    
22. end;
    
23. 
    
24. select  * from v_$db_object_cache   doc where doc.name='ADD_JOB_HISTORY'  ;

复制代码