加入收藏 | 设为首页 | 会员中心 | 我要投稿 李大同 (https://www.lidatong.com.cn/)- 科技、建站、经验、云计算、5G、大数据,站长网!
当前位置: 首页 > 百科 > 正文

0 Oracle_052_lesson_p12

发布时间:2020-12-12 13:25:32 所属栏目:百科 来源:网络整理
导读:Database Maintenance 维护DB you should be able to: Manage optimizer statistics Manage the Automatic Workload Repository (AWR) 自动负载知识库 Use the Automatic Database Diagnostic Monitor (ADDM) 自动数据库诊断监控 Describe and use the advis
Database Maintenance 维护DB

you should be able to:
Manage optimizer statistics
Manage the Automatic Workload Repository (AWR) 自动负载知识库
Use the Automatic Database Diagnostic Monitor (ADDM) 自动数据库诊断监控
Describe and use the advisory framework
Set alert thresholds 阈值
Use server-generated alerts
Use automated tasks

AWR --(严重错误)--> ADR 自动诊断知识库

术语
Automatic Workload Repository (AWR): Infrastructure for data gathering,analysis,and solutions recommendations
AWR Baseline: AWR基线 A set of AWR snapshots for performance comparison
Metric: 度量值 Rate of change in a cumulative statistic
Statistics: 统计信息Data collections providing database and object detail
Optimizer statistics: 优化器统计信息Used by query optimizer
Database statistics: 数据库统计信息Used for performance
Threshold: 阈值A boundary value againstwhich metric values are compared

(编辑:李大同)

【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容!

    推荐文章
      热点阅读