第8次：2014-01-13

botang · 发表于 2015-1-14 09:18:31

本帖最后由 botang 于 2015-1-19 12:07 编辑

select  * from dba_tables t
where t.owner='HR' and t.table_name='EMPLOYEES';

alter table hr.employees  storage (buffer_pool keep ) ;

select name , value  from v$parameter where name like 'db_2k%';

select  *  from dba_tab_columns tc where tc.OWNER='HR' and tc.TABLE_NAME='EMPLOYEES';

select * from v$sgastat;

select  * from v$sga_dynamic_components;

select  * from v$log;