11g自动收集统计信息

13Automatic Optimizer Statistics Collection

10年积累的成都做网站、网站制作经验，可以快速应对客户对网站的新想法和需求。提供各种问题对应的解决方案。让选择我们的客户得到更好、更有力的网络服务。我虽然不认识你，你也不认识我。但先网站策划后付款的网站建设流程，更有富民免费网站建设让你可以放心的选择与我们合作。

打开：

BEGIN
  DBMS_AUTO_TASK_ADMIN.ENABLE(
     client_name => 'auto optimizer stats collection' 
,    operation   => NULL
,    window_name => NULL
);
END;
/

关闭：

BEGIN
  DBMS_AUTO_TASK_ADMIN.DISABLE(
     client_name => 'auto optimizer stats collection'
,    operation   => NULL 
,    window_name => NULL
);
END;
/

数据库监视这每个表的变化信息，当变化超过10%就自动收集统计信息：

（查询统计信息是否过期？DBA_TAB_STATISTICS）

Monitoring tracks the approximate number of INSERTs, UPDATEs, and DELETEs for that table and whether the table has been truncated since the last time statistics were gathered. You can access information about changes of tables in the USER_TAB_MODIFICATIONS view. Following a data-modification, there may be a few minutes delay while Oracle Database propagates the information to this view. Use the DBMS_STATS.FLUSH_DATABASE_MONITORING_INFO procedure to immediately reflect the outstanding monitored information kept in the memory.

The GATHER_DATABASE_STATS or GATHER_SCHEMA_STATS procedures gather new statistics for tables with stale statistics when the OPTIONS parameter is set to GATHER STALE orGATHER AUTO. If a monitored table has been modified more than 10%,then these statistics are considered stale and gathered again.

When to Use Manual Statistics？

• Volatile tables that are deleted or truncated and rebuilt during the course of the day.

• Objects that are the target of large bulk loads which add 10% or more to the object's total size.

 

新闻标题：11g自动收集统计信息
网页网址：https://www.cdcxhl.com/article12/jsscdc.html

成都网站建设公司_创新互联，为您提供外贸网站建设、域名注册、电子商务、网站设计公司、标签优化、网站制作

广告

声明：本网站发布的内容（图片、视频和文字）以用户投稿、用户转载内容为主，如果涉及侵权请尽快告知，我们将会在第一时间删除。文章观点不代表本网站立场，如需处理请联系客服。电话：028-86922220；邮箱：631063699@qq.com。内容未经允许不得转载，或转载时需注明来源： 创新互联