课程第56次：2016-07-24星期日上午

botang · 发表于 2016-7-23 22:14:05

本帖最后由 botang 于 2016-7-24 16:40 编辑

课程第56次：2016-07-24星期日上午
【上完1Z0-052的第12章】AWR简介
【上完1Z0-051】：共12章（0 1 2 3 4 5 6 7 8 9 10 11）
【1Z0-052】：共18章（0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18）
【1Z0-053】：共15章（0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20）
表示已经上过的，表示还没上的。

参考别期的帖子：
https://www.botangdb.com/forum.php?mod=viewthread&tid=266&extra=page%3D1
统计信息：

select * from dba_tab_stat_prefs t where t.owner='SH'
and t.table_name='SALES';
select t.num_rows from dba_tables t
where t.owner='HR' and t.table_name='T04209_UNAME';
select *
from dba_tab_col_statistics tcs
where tcs.owner='HR' and tcs.table_name='T04209_UNAME';
select i.num_rows
from dba_indexes i where i.owner='HR' and i.table_name='T04209_UNAME';
begin
dbms_stats.delete_table_stats (ownname => 'HR' , tabname => 'T04209_UNAME'
) ;
end;
---
begin
dbms_stats.set_table_prefs('HR','T04209_UNAME','PUBLISH','FALSE');
end;
begin
dbms_Stats.gather_table_stats('HR','T04209_UNAME',
method_opt =>'for columns uvalue size 254 for all columns size auto');
end;
select * from dba_tab_pending_stats;
begin
dbms_Stats.publish_pending_stats('HR','T04209_UNAME');
end;
---

复制代码

stateful 告警

create tablespace tbs05212 datafile size 10M autoextend off ;
select bytes/1024/1024 from dba_segments s where s.segment_name='T04209_UNAME';
alter table hr.t04209_uname move tablespace tbs05212;
select * from dba_outstanding_alerts o order by o.time_suggested desc ;
select * from dba_alert_history ah order by ah.time_suggested desc;
alter tablespace tbs05212 add datafile size 40M;
----
select * from dict where table_name like 'V$%HISTOG%';
select * from V$SQL_WORKAREA_HISTOGRAM;
select * from dict where table_name like 'V$%ADVICE';
select * from V$SHARED_POOL_ADVICE;
select * from V$DB_CACHE_ADVICE;

复制代码