如何关闭统计信息自动分析?
SQL> select t.owner,t.job_name,t.last_start_date,t.last_run_duration,t.next_run_date,t.comments
2 from dba_scheduler_jobs t where t.comments like \'%statistics collection%\'
3 ;
------------------------------ ------------------------------ -------------------------------------------------------------------------------- --------------------------------------- -------------------------------------------------------------------------------- --------------------------------------------------------------------------------
SYS GATHER_STATS_JOB 17-OCT-07 10.00.03.137638 PM +08:00 +000000000 00:02:17.909439 Oracle defined automatic optimizer statistics collection job
db158:/home/oracle>$sqlplus "/ as sysdba"
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
SQL> exec dbms_scheduler.enable(\'SYS.GATHER_STATS_JOB\') ;
扫一扫订阅我的微信号:IT技术博客大学习
- 作者:Incessant 来源: Incessant
- 标签: 自动分析
- 发布时间:2009-10-11 12:32:39
- [654] Go Reflect 性能
- [24] 正态分布的前世今生(一)
- [14] rsync同步的艺术
- [14] Cuckoo Filter:设计与实现
- [13] Linux Used内存到底哪里去了?
- [12] 深入浅出选择类排序算法(简单选择排序,堆排序
- [12] 什么是DNS劫持和DNS污染?
- [12] 关于RDS只读实例延迟分析
- [11] jQuery性能优化指南
- [11] vim入门,进阶与折腾