Oracle 培训笔记 9.11 主动维护

主动维护 proactive maintenance

metric: 度量
threshold 阈值
warning：70
critical：90

select * from dba_users;
alter user dbsnmp identified by dbsnmp account unlock;
alter user sysman identified by sysman account unlock;

c:\>emca -config dbcontrol db -repos recreate

输入以下信息:
数据库 SID: mysid
监听程序端口号: 1521
SYS 用户的口令:
DBSNMP 用户的口令:
SYSMAN 用户的口令:
通知的电子邮件地址 (可选):
通知的发件 (SMTP) 服务器 (可选):
-----------------------------------------------------------------

访问
http://localhost:1158/em

增加表空间
create tablespace tbs datafile 'E:\oracle\product\10.2.0\oradata\mydb\tbs.dbf' size 10M;

设置告警阈值
begin
dbms_server_alert.set_threshold(metrics_id =>dbms_server_alert.TABLESPACE_PCT_FULL,
warning_operator =>dbms_server_alert.OPERATOR_GT,
warning_value =>50,
critical_operator =>dbms_server_alert.OPERATOR_GT,
critical_value =>60,
observation_period =>1,
consecutive_occurrences =>2,
object_type =>dbms_server_alert.OBJECT_TYPE_TABLESPACE,
instance_name =>null,
object_name =>'TBS');
end;

查询设置
select * from dba_thresholds;

模拟
create table big tablespace tbs as select * from dba_objects;
insert into big select * from big;

通过em观察表空间使用状况

通过em观察告警
select * from dba_outstanding_alerts;
select * from dba_alert_history;