zhuqibs
作者zhuqibs·2020-04-30 22:46
软件开发工程师·Adidas

Oracle Rac -- How to Disable Automatic Statistics Collection in 11g

字数 455阅读 664评论 0赞 0

Applies to:

Oracle Server - Enterprise Edition - Version: 11.1.0.6 to 11.2.0.1 - Release: 11.1 to 11.2
Information in this document applies to any platform.
Goal

How to disable automatic statistics collection in 11g
Solution

The command to disable automatic optimizer statistics collection is:
BEGIN
DBMS_AUTO_TASK_ADMIN.DISABLE(
client_name => 'auto optimizer stats collection',
operation => NULL,
window_name => NULL);
END;
/

如果觉得我的文章对您有用,请点赞。您的支持将鼓励我继续创作!

0

添加新评论0 条评论

Ctrl+Enter 发表

作者其他文章

相关文章

相关问题

相关资料

X社区推广