首页 > 数据库技术 > 详细

设置 STATISTICS_LEVEL = BASIC 会禁用哪些数据库特性

时间:2015-05-28 12:40:14      阅读:362      评论:0      收藏:0      [点我收藏+]

设置 STATISTICS_LEVEL = BASIC 会禁用一下oracle 的功能特性

  • Automatic Workload Repository (AWR) Snapshots

  • Automatic Database Diagnostic Monitor (ADDM)

  • All server-generated alerts

  • Automatic SGA Memory Management  (ASMM)和自动内存管理

  • Automatic optimizer statistics collection

  • Object level statistics

  • End to End Application Tracing (V$CLIENT_STATS)

  • Database time distribution statistics (V$SESS_TIME_MODEL and V$SYS_TIME_MODEL)

  • Service level statistics

  • Buffer cache advisory

  • MTTR advisory

  • Shared pool sizing advisory

  • Segment level statistics

  • PGA Target advisory

  • Timed statistics

  • Monitoring of statistics

设置 STATISTICS_LEVEL = BASIC 会禁用哪些数据库特性

原文:http://blog.csdn.net/lixora/article/details/46119627

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!