|
1Z0-052第12章
1Z0-052共19章(上完18章),1Z0-053共21章(上完17章)和1Z0-063多租户部分共9章(上完0章)
总共上完全部49章中的35章
关于AWR的直接内存访问模式:
- select substr(t.table_name,3,1),count(*) from dba_tables t
- where t.tablespace_name='SYSAUX'
- and t.table_name like 'WR_$\_%' escape '\'
- group by substr(t.table_name,3,1);
复制代码 10g AWR由 H M I 三类表构成。
11g AWR由 H M I R四类表构成。
12c AWR由 H M I R P五类表构成。
- select * from dba_alert_history ;
- select * from dba_outstanding_alerts;
- select * from dba_views where view_name='INT$DBA_OUTSTANDING_ALERTS';
- select * from dba_views where view_name='INT$DBA_ALERT_HISTORY';
- wri$_alert_history
- wri$_alert_outstanding
复制代码
定量告警,症状解除后,信息自动从dba_outstanding_alerts转移到dba_alert_history。
V$视图是数据库的统计信息。是AWR之源。
DBA_TABLES和DBA_TAB_COL_STATISTICS这类视图是Optimizer统计信息。是CBO执行计划之源。
AWR快照取自前者。快照要成对(包括中间的)出现。
V$视图的标准收集靠以下3个参数的设置:
- statistics_level string TYPICAL
- timed_os_statistics integer 0
- timed_statistics boolean TRUE
复制代码- select num_rows, t.LAST_ANALYZED from DBA_TABLES t
- where t.OWNER='HR' and t.TABLE_NAME='T_BIG';
-
- select count(*) from hr.t_big;
- select * from DBA_TAB_COL_STATISTICS tcs
- where tcs.OWNER='HR' and tcs.TABLE_NAME='T_BIG';
-
-
- begin
- dbms_stats.gather_table_Stats('HR','T_BIG',
- estimate_percent=>100,
- method_opt => 'for all columns size auto');
- end;
-
- select dbms_Stats.get_prefs('STALE_PERCENT') from dual;
- select dbms_Stats.get_prefs('PUBLISH') from dual;
-
-
- select * from dba_tab_stat_prefs;
- select * from dba_tab_pending_stats;
-
- begin
- dbms_stats.gather_schema_stats('HR');
- end;
- begin
- dbms_stats.set_table_prefs('HR','T_BIG','STALE_PERCENT','1');
- end;
-
- begin
- dbms_stats.set_table_prefs('HR','T_BIG','METHOD_OPT','for columns text size 254 for all columns size auto');
- end;
-
- begin
- dbms_stats.set_table_prefs('HR','T_BIG','PUBLISH','FALSE');
- end;
-
-
- begin
- dbms_stats.gather_database_stats;
- end;
- select * from dba_tab_pending_stats;
复制代码
|
|