（52-37）第58次：2016-03-02星期三

admin · 发表于 2016-3-3 10:23:21

（52-35）上完1Z0-052第13章
（52-36）上完1Z0-053第13章
（52-37）上完1Z0-053第14章

2016-03-02a.sql:

select * from v$memory_dynamic_components
minus
select * from v$sga_dynamic_components;
select s.COMPONENT , s.CURRENT_SIZE/1024/1024
from v_$sga_dynamic_components s;
---
select * from v$fixed_table where name like 'V%ADVICE';
select * from V$MEMORY_TARGET_ADVICE;
select * from V$SGA_TARGET_ADVICE;
select * from V$PGA_TARGET_ADVICE;
select * from V$DB_CACHE_ADVICE;
select * from V$SHARED_POOL_ADVICE;
--
select * from V$MEMORY_TARGET_ADVICE;
select * from V$SGA_TARGET_ADVICE;
select * from V$PGA_TARGET_ADVICE;
select * from V$SHARED_POOL_ADVICE;
select * from V$DB_CACHE_ADVICE;
---
select s.SID, s.USERNAME, n.NAME, se.VALUE
from v_$session s , v_$sesstat se , v_$statname n
where s.SID=se.SID and se.STATISTIC#=n.STATISTIC#
and s.TERMINAL='pts/3' and n.NAME='redo size';
select o.object_name, o.status
from dba_objects o
where o.owner='HR' and o.object_name='PROC1';
alter procedure hr.proc1 compile;
select * from v$sga_dynamic_components;
alter system set db_keep_cache_size=1M;
select t.buffer_pool
from dba_tables t where t.owner='HR' and t.table_name='EMPLOYEES';
alter table hr.employees storage ( buffer_pool keep ) ;
select * from v_$db_object_cache o where
o.OWNER='HR' and o.NAME='PROC1';
begin
dbms_shared_pool.keep( 'HR.PROC1');
end;
---
select * from v$memory_resize_ops;
---
select s.sql_id ,s.sql_hash_value
from v_$session s where s.terminal='pts/3';
---
select * from v$sqlarea where sql_id='dh73w3ss300hp';
---
select * from dba_tab_stat_prefs;
begin
dbms_stats.set_table_prefs('SH','SALES','STALE_PERCENT','13');
begin
dbms_stats.gather_schema_stats('SH');
end;
end;

复制代码